Posted: February 26th, 2023
attached
The congestive heart failure (CHF) subset comes from the Medical Provider Analysis and Review (MedPAR)
data set
Download data set
. MedPAR is a file that is distributed by Center for Medicare and Medicaid Services (CMS), the entity that administers the Medicare program. The file contains data for all inpatient Medicare admissions. The
Expanded Modified MedPAR Links to an external site.
PDF contains the documentation for the full file.
For this assignment, you will use Microsoft Excel to create a data dictionary, work with data records, and create tables and charts. Then you will write a summary of your findings.
Create a Data Dictionary
A data dictionary provides details about specific items in a database and includes the table name, attributes or field names, a description of each attribute or field name, the data type (Alpha, numeric, alpha-numeric) and the field length.
Using the
Links to an external site.
Specifications Manual for Joint Commission National Quality Measures (v2015B) Links to an external site.
, the U.S. Census Bureau definitions, or other scholarly source, create a data dictionary for the following variables:
· Age
· Gender
· Admission Source
· Discharge Destination
Work with the MEDPAR CHF Data Records to Create your MS Excel File
Use VLOOKUP to sort the data in your worksheet. For help using VLOOKUP review the
Excel Help Center Links to an external site.
web page. For additional assistance with VLOOKUP, review the
VLOOKUP Steps Help
Download VLOOKUP Steps Help
resource.
Complete the following:
· Insert (add) a column for gender description.
· Populate that column using VLOOKUP.
· Insert (add) a column for discharge destination description.
· Populate that column using VLOOKUP.
Create Tables and Charts
Complete the following:
· 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 age group grouped by gender.
· Use a PivotChart to create a stacked bar of discharge status by diagnosis-related group (DRG).
· Use a PivotChart to create a pie chart of age category.
· Create a scatter plot of the length of stay (LOS) by accommodation charges.
· Create a charge per diem chart.
Prepare a One-Page Summary of Your Findings
Complete the following:
· Summarize the history and purpose of the MedPAR (CHF) database.
· Analyze the findings seen in your data tables. Review the Wring Center’s
Summary Vs. Analysis Links to an external site.
web page for additional information.
· 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 age group 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, peer-reviewed, or credible sources.
Place an order in 3 easy steps. Takes less than 5 mins.