question archive Pivot Table Assignment Instructions A pivot table is an Excel tool that summarizes and analyses larger data tables
Pivot Table Assignment Instructions A pivot table is an Excel tool that summarizes and analyses larger data tables
Subject:Health SciencePrice: Bought3
Pivot Table Assignment Instructions
A pivot table is an Excel tool that summarizes and analyses larger data tables. For this assignment you will download a publicaly-available dataset (Hospital Compare), create a pivot table, and summarize and draw conclusions from your results.
Step 1: Go here: to the zip file
Step 2: Scroll down and click on “Download CSV Flat Files (Revised) Now”. (blue box)
-this will download a .zip file of ALL the current CMS Hospital Compare data.
Step 3: Take some time and skim the data dictionary (the only .pdf in the .zip file). Pick a topic that interests you: timely care, outcomes, patient satisfaction, etc..
What is Hospital Compare?
Hospital Compare is a dataset / website that contains quality-related information for over 4000 Meidcare-Certified hospitals. These data are publicly-available and free to access. More detailed descriptions can be found at: https://www.medicare.gov/hospitalcompare/About/What-Is-HOS.html .
Step 4: After you have decided on a topic, open up the corresponding Excel file from the .zip folder. Look across the first horizontal row (Row 1) for all variable labels.
Step 5: With cell “A1” selected, click on Insert – PivotTable.
Four boxes will appear: Rows, Columns, Filters, and Values. You will now, construct a table using these four boxes. This will be some trial and error – but it will help to draw out a table using pen and paper for how YOU want the table to appear in Excel. Perhaps Filter by State=TX; Row=Hospital Name; Column = Quality MetricX; Value = Quality Star Rating. This is just an example – try it out – but come up with your own!
Report format:
A pivot table is an Excel tool that summarizes and analyses larger data tables. For this assignment you will download a publicaly-available dataset (Hospital Compare), create a pivot table, and summarize and draw conclusions from your results.
3 pages in MS Word Max. An introductory paragraph describing what you are studying and WHY its important. Copy / paste your pivot table next. Then a results/discussion section describing your results and what value they have.
