Data 8: Statistics Use the spreadsheet template posted on D2L with these instructions. (Save your Microsoft Excel spreadsheet by your rst-last name and assignment number. (e.g. stacey- brook1.xlsx). [50 points] a. In the \"Bar Chart\" worksheet, copy and paste the Netix subscriber data into cells B2 through E12. (I posted the Netix data (see Sheet 2) in Excel for this under Lecture07 on D2L). Create a Bar Chart in Excel (as shown in Lecture0702) of Netix Subscribers by Geographic area for all eleven quarters. In the \"Pie Chart" worksheet, copy and paste the video game market share data for the years 2015 to 2019 in cells B2 through E6, and create Pie Charts in Excel of the Video Game Console Market Share (as shown in Lecture0703; you will have ve different pie charts). In the \"Line Chart\" worksheet, copy and paste the Jan. to June 2019 and Jan. to June 2020 data in columns A through H (column E is blank). Create a Line Chart in Excel of CTA Rail Boarding's for the January 1 to June 30 time periods for the 2019 and 2020 years as shown in Lecture0704. NOTE: The data is not always posted chronologically. If it is not, you will need to highlight the 5 columns and sort by service_date (Oldest to Newest) in the spreadsheet you download from D2L. I provided information as to how to Sort data in Excel in Lecture 05-02. In the \"Scatterplot Chart\" worksheet, copy and paste the monthly gasoline prices and automobile sales from January 1995 to December 2019 in cells A2 through D301 (as shown in Lecture07-05), and create a Scatterplot Chart in Excel as shown in Lecture07-05 including the trend line and statistical results. In the \"Per Capita Income\" worksheet, copy and paste the US Per Capita Income (I posted this data in Lecture08 on D2L) data in columns A through D. PCI 1 = 2018 and PCI 2 = 2019. In the \"Statistics\" worksheet, calculate the mean, median and standard deviation for PCI 1 in cells B2 to B4, and calculate the mean, median and standard deviation for PCI 2 in cells C2 to C4, (include all formulas in the spreadsheet). In the \"Statistics 2\" worksheet, calculate the percentiles (each 10\"1 percentile) for PCI 2 in cells F2 to F10. In the \"Statistics 3\" worksheet, calculate the correlation between Per Capita Income 1 and Per Capita Income 2 in cell B2; calculate the value (probability) of the ttest in cell B3 (include all formulas in the spreadsheet). [continued on the next page]