Part 3 - Regression Line Equation In this part, you will be building a regression line equation that relates the number of cases and the number of deaths in the first 10 states. Round all computed measures to three decimal places and include math symbols. In your word processor (Word or Google Docs), indicate the following: A. let x represent the number of cases and compute o the sample mean x using the code "=AVERAGE(A2:A11)" in your spreadsheet; o the sample standard deviation s, using the code "=STDEV.S(A2:A11)" in your spreadsheet; B. let y represent the number of deaths and compute the sample mean y using the code "=AVERAGE(B2:B11)" in your spreadsheet; o the sample standard deviation s, using the code "=STDEV.S(B2:811)" in your spreadsheet; C. compute the slope a using the appropriate formula (show your work); D. compute the y-intercept b using the appropriate formula (show your work); E. write the regression line equation y = ax + b by replacing a and b with the computed values F. use the regression line equation to compute the predicted number of deaths y when a state has x = 4, 000, 000 cases; G. indicate which value, between y and y, is the best predicted number of deaths for a state with x = 4, 000, 000 cases, and explain your reasoning.Part 1 - Scatter Plot In your spreadsheet (Excel or Google Sheets) create a scatter plot. Copy and paste the scatter plot onto your word processor (Word or Google Docs), right after the table of data values. Use complete sentences to describe your scatter plot. Make sure to include the following: 0 state whether there appears to be a linear correlation between the number of Coronavirus cases and the number of deaths, and explain your reasoning; 0 only in case of a linear correlation, state whether the linear correlation is weak or strong, positive or negative, and explain your reasoning; 0 state whether there is an outlier that deviates the correlation; in case of an outlier, state the number of cases, number of deaths and the U. 8. state for that outlier. Part 2 - Correlation Coefficient In your spreadsheet (Excel of Google Sheets), compute the correlation coefficient / using the appropriate code as indicated in lecture 23.1. Write the value of r without rounding in your word processor (Word or Google Docs). Use complete sentences to analyze the correlation coefficient / including the following: . state whether the value of the correlation coefficient r suggests a linear correlation between the number of Coronavirus cases and the number of deaths, and explain your reasoning; . only in case of a linear correlation, state whether the correlation coefficient r shows a positive or negative linear correlation, and explain your reasoning.PROBLEM 2 You will be using Coronavirus data from the webpage Worldometer. In particular, you will use the values for total cases and total deaths in the top 10 states listed in the site. These values cannot be chosen at random, so make sure to use values from the top 10 states only. Open a spreadsheet (Excel or Google Sheets) and insert data as follows: . type headings "Cases" in cell A1, "Deaths" in cell B1 and "State" in cell C1. . In the A column, starting in cell A2, type the values of total cases from the first 10 states (do no include commas when typing the numbers). . In the B column, starting in cell B2, type the values of total deaths from the first 10 states (do no include commas when typing the numbers). . In the C column, starting in cell C2, type the names of the first 10 states. Select and copy the content from cells A1 though C11 containing headings, data values and names of the states. Open a word processor (Word or Google Docs) and paste the content from the spreadsheet. Proceed to work each part separately. Part 1 - Scatter Plot
