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 Dictionary
    Find definitions for coded variables:
    • Age
    • Gender
    • Admission Source
    • Discharge Destination
  • Review: Vlookup
    Vlookup 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 

  1. 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.
  2. Must include a title page with the following:
    • Title of paper
    • Student’s name
    • Course name and number
    • Instructor’s name
    • Date submitted
  3. Must begin with an introductory paragraph that has a succinct thesis statement.
  4. Must use at least two scholarly sources, excluding the textbooks and course articles.
  5. Must document all sources in APA style, as outlined in the Ashford Writing Center.
  6. Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"