PROBLEM 1 (There are 5 parts in this problem) Part 1 - Organizing Data Values You will be using Coronavirus data from the webpage Worldometer . In particular, we will look at the columns for total cases and total deaths in the first top 10 states listed in the site. These values cannot be chosen at random, so make sure to use values from the first top 10 states only. Please watch the tutorial videos in the project to guide you but keep in mind that the numbers used in the videos are a lot smaller than the ones you see on the Worldometer website. Use the following guidelines.

Open a spreadsheet (Excel or Google Sheets) and create a table by inserting data as follows:

• For the headings, type "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 top 10 states (do no include commas when typing these numbers).
• In the B column, starting in cell B2, type the values of total deaths from the first top 10 states (do no include commas when typing these numbers).
• In the C column, starting in cell C2, type the names of the first top 10 states.

Select and copy the content from cells A1 though C11 containing headings, data values and names of the states. Refer to the tutorial videos as needed.

Paste the content from the spreadsheet into this document, right below.

HERE YOU WILL PASTE THE TABLE FROM YOUR SPREADSHEET

Part 2 - Scatterplot From the data values on your spreadsheet, create a scatterplot. Make sure to watch the tutorial on how to create a scatter plot in a spreadsheet and copy/paste it onto this document.

HERE YOU WILL PASTE THE SCATTERPLOT FROM YOUR SPREADSHEET

Use complete sentences to describe your scatter plot. Make sure to include the following:

• state whether there appears to be 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 linear correlation is weak, moderate, or strong, as well as positive or negative, and explain your reasoning.
• state whether there is an outlier that clearly deviates the correlation; for the outlier (if there is one), state the number of cases, number of deaths and the U. S. state for that outlier.

Part 3 - Correlation Coefficient In your spreadsheet (Excel of Google Sheets), compute the correlation coefficient r using the appropriate code as indicated in lecture 23.1. Write the value of the correlation coefficient without rounding: = Use complete sentences to analyze the correlation coefficient including the following:

• state whether the value of the correlation coefficient 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 shows a positive or negative linear correlation, and explain your reasoning.

Part 4 - Linear Regression 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 top 10 states. Refer to lecture 23.2.

Use appropriate math symbols and round all results to three decimal places: A. let represent the number of cases

o using the code "=AVERAGE(A2:A11)" in your spreadsheet, compute =

o using the code "=STDEV.S(A2:A11)" in your spreadsheet, compute =

B. let represent the number of deaths

o using the code "=AVERAGE(B2:B11)" in your spreadsheet, compute = o using the code "=STDEV.S(B2:B11)" in your spreadsheet, compute =

C. using the appropriate formula from lecture 23.2, compute and show your work for the slope

D. using the appropriate formula from lecture 23.2, compute and show your work for the -intercept

E. Use the slope and - intercept values and write the regression line equation

F. Use the regression line equation and compute , the predicted number of deaths, if a state reaches ,, number of cases. Show your work.

Part 5 - Best Predicted Value Between the predicted value of and the mean value of , indicate the BEST predicted number of deaths if a state reaches 6,000,000 number of cases. Explain your reasoning.

PROBLEM 2 (There are 5 parts in this problem) Part 1 - Organizing Data Values Assume that, in the state of New York, measures to prevent the spread of Covid-19 were not followed. As a consequence, the number of deaths climbed to about ,. In your spreadsheet (Excel or Google Sheets), use the same Coronavirus data values you had from problem 1 but this time, replace the number of deaths in the state of New York with ,.

Select and copy the updated content from cells A1 though C11 containing headings, updated data values and names of the states. Refer to the tutorial videos as needed.

Paste the content from the spreadsheet into this document, right below.

HERE YOU WILL PASTE THE TABLE FROM YOUR SPREADSHEET

Part 2 - Scatterplot Assume that, in the state of New York, measures to prevent the spread of Covid-19 were not followed. As a consequence, the number of deaths climbed to about ,.

From the updated data values on your spreadsheet, create a scatterplot. Make sure to watch the tutorial on how to create a scatter plot in a spreadsheet and copy/paste it onto this document.

HERE YOU WILL PASTE THE SCATTERPLOT FROM YOUR SPREADSHEET

Use complete sentences to describe your scatter plot. Make sure to include the following:

• state whether there appears to be 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 linear correlation is weak, moderate, or strong, as well as positive or negative, and explain your reasoning.
• state whether there is an outlier that clearly deviates the correlation; for the outlier (if there is one), state the number of cases, number of deaths and the U. S. state for that outlier.

Part 3 - Correlation Coefficient Assume that, in the state of New York, measures to prevent the spread of Covid-19 were not followed. As a consequence, the number of deaths climbed to about ,.

In your spreadsheet (Excel of Google Sheets), use the updated data values and compute the correlation coefficient r using the appropriate code as indicated in lecture 23.1.

Write the value of the correlation coefficient without rounding: =

Use complete sentences to analyze the correlation coefficient including the following:

• state whether the value of the correlation coefficient 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 shows a positive or negative linear correlation, and explain your reasoning.

Part 4 - Linear Regression Equation Assume that, in the state of New York, measures to prevent the spread of Covid-19 were not followed. As a consequence, the number of deaths climbed to about ,.

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 top 10 states. Refer to lecture 23.2.

Use appropriate math symbols and round the all results to three decimal places:

A. let represent the number of cases

o using the code "=AVERAGE(A2:A11)" in your spreadsheet, compute =

o using the code "=STDEV.S(A2:A11)" in your spreadsheet, compute

=

B. let represent the number of deaths a. using the code "=AVERAGE(B2:B11)" in your spreadsheet, compute =

b. using the code "=STDEV.S(B2:B11)" in your spreadsheet, compute =

C. using the appropriate formula from lecture 23.2, compute and show your work for the slope

D. using the appropriate formula from lecture 23.2, compute and show your work for the -intercept

E. Use the slope and - intercept values and write the regression line equation

F. Use the regression line equation and compute , the predicted number of deaths, if a state reaches ,, number of cases. Show your work.

Part 5 - Best Predicted Value Assume that, in the state of New York, measures to prevent the spread of Covid-19 were not followed. As a consequence, the number of deaths climbed to about ,.

Between the predicted value of and the mean value of , indicate the BEST predicted number of deaths if a state reaches ,, number of cases. Explain your reasoning.

(PLEASE PROVIDE STEP BY STEP WORK)