Assignment #11 - Excel Lab 2 - Pivot Tables and Charts TASKS:

Q1

Go to the AHRQ Datatools websiteLinks to an external site. and select/download a dataset to use. Make sure to reference which dataset you used in your assignment submission. Use that dataset to make two different Excel pivot tables and charts. Review the steps to creating a pivot chartLinks to an external site. as needed. Make sure to provide a descriptive chart title and axis labels for each chart. Each pivot chart should be on a separate worksheet tab in your Excel file. Provide one sentence that sums up the key point as shown in the chart. Q2

Explore the Medicare Data website - see: https://data.medicare.gov/ and select/download a dataset to use. Make sure to reference which dataset you used in your assignment submission. Use that dataset to make two different Excel pivot tables and charts. Make sure to provide a descriptive chart title and axis labels for each chart. Each pivot chart should be on a separate worksheet tab in your Excel file. Provide one sentence that sums up the key point as shown in the chart. Criteria Dataset Selected a dataset to use from the AHRQ datatools website and dataset from the Medicare data website. Referenced the specific dataset used for the assignment. Pivot Tables Created four pivot tables - 2 for each dataset. Each pivot table should be on a separate tab in the Excel spreadsheet. Pivot Chart Created four pivot charts - two for each dataset. Followed good graphing practices including a chart title, axis titles, data descriptions as needed. Summary Provided a one sentence summary of key point for each chart