Lab3-2TimeSeries Read Problem 23 p. 80 in your textbook. You can use Excel for this. You can do it in R but it is quicker in Excel. 1. Look at the All Data worksheet in the data workbook. Make side by side boxplots of the data. (Highlight the data in the sunspot and CancerRate columns and go to Insert->Statistics Chart and choose the boxplot.) Paste it into a word document to use in your report. 2. Go to the Time Series worksheet and make and x,y-scatterplot with the dots connected for the year and CancerRate data. (Go to Insert->x,y-scatter and choose a style that connects the dots.) Past it into your report. 3. Briefly explain, based on these two charts, whether the effect of sunspots or changes over time are more influential in explaining the cancer rate. 4. Write up your report including the charts and explanation and submit it to Brightspace. Year CancerRate 1938 0.8 1939 1.3 1940 1.4 1941 1.2 1942 1.7 1943 1.8 1944 1.6 1945 1.5 1946 1.5 1947 2 1948 2.5 1949 2.7 1950 2.9 1951 2.5 1952 3.1