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 result

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 result
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.