3) After you create your pivot table, it is time to create your pivot chart. In the graph, you should show Total Case per Capita and New Case per Capita day by day for each country. You will have two axes in the graph. Total Case per Capita will be displayed in the right axis and New Case per Capita will be displayed in the left axis. New Case per Capita will be Line Type and Total Case per Capita will be Clustered Column. Then move the chart into a new worksheet and name the worksheet as JH Pivot Chart. The final chart should look like Figure 3. (20 points)

4) Now, you will start working with Google Community Mobility Data. Create a Pivot Table from Google Community Mobility Data that includes Country and Date as Rows. Insert retail and workplaces as Values. Create also a new calculated field called Google Community Index equals the average of retail and workplaces which means (retail + workplaces)/2. Insert your new calculated field as Values. Dont forget to filter countries. Name this Pivot Table worksheet as Google Pivot Table. (20 points)

5) After you create your Google pivot table, it is time to create your second pivot chart. In the graph, you should show retail, workplaces and our Google Community Index. Retail and Workplaces will be shown as Line Chart and our new Google Community Index will be displayed as Area. Then move the chart into a new worksheet and name the worksheet as Google Pivot Chart. The final chart should look like Figure 4. (20 points