Posted: February 26th, 2023

week 3 assignment

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.