Health statistics
CHF Study
The CHF dataset comes from the MedPAR dataset. MedPAR is a file that is distributed by CMS (the entity that administers the Medicare program). The file contains data for all inpatient Medicare admissions. The documentation for the full file is available here.
(Reminder: There are several resources listed in this week’s Required Resources that use the pivot table.) For this assignment, you will use excel to create a data dictionary, combine data records and create tables and charts.
Create a Data DictionaryFind definitions for coded variables:
Age
Gender
Admission Source
Discharge Destination
Review: VlookupVlookup is a function in Excel that allows the user to combine records from two worksheets.
Add a column for gender description
Populate that column using vlookup
Add a column for discharge destination description
Populate that column using vlookup
Using Excel for Charts/Tables
Create a table of gender (with %)
Create a two-way table of gender and age group
Create a pie chart of gender percentages (from #1)
Create a grouped bar chart of agegroup grouped by gender
Use PivotChart to create a stacked bar of Discharge status by DRG
Use PivotChart to create a pie chart of age category
Create a scatter plot of LOS by accommodation charges
Create a charge per diem chart
Prepare a one page summary of your findings.
Summarize the history and purpose of the MedPAR database.
Describe the findings from the two-way table of gender and age group
Describe the findings from the pie chart of gender percentages
Describe the findings from the grouped bar chart of agegroup grouped by gender
Describe the findings from the scatter plot of LOS by accommodation charges
Describe the findings from the charge per diem chart
Include a minimum of two scholarly references
The formative paper
Must be one to two double-spaced pages in length (excluding title and reference pages), and formatted according to APA style as outlined in the Ashford Writing Center.
Must include a title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must begin with an introductory paragraph that has a succinct thesis statement.
Must use at least two scholarly sources, excluding the textbooks and course articles.
Must document all sources in APA style, as outlined in the Ashford Writing Center.
Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.
The post Health statistics first appeared on Nursing School Essays.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
