simple data analysis

CHF Study

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your paper.

Write My Essay For Me

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.

“WE’VE HAD A GOOD SUCCESS RATE ON THIS ASSIGNMENT. PLACE THIS ORDER OR A SIMILAR ORDER WITH HOMEWORK AIDER AND GET AN AMAZING DISCOUNT”

The post simple data analysis appeared first on Homeworkaider.