PROBLEM 1(There are 5 parts in this problem)

Part 1 - Organizing Data Values

You will be using Coronavirus data from the webpageWorldometer. In particular, we will look at the columns fortotal cases andtotal 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 PASTETHE TABLE FROM YOUR SPREADSHEET

Part 2 - Scatterplot

From the data values on your spreadsheet, create a scatter plot. 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 PASTETHE 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 coefficientrusing the appropriate code as indicated in lecture 23.1.

Write the value of thecorrelation coefficient without rounding:

r=

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:

1. let represent the number of cases
   • using the code "=AVERAGE(A2:A11)" in your spreadsheet, compute

x=

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

sx=

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

y=

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

sy=

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

a=

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

b=

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

1. Use the regression line equation and computey, the predicted number of deaths, if a state reaches6,000,000 number of cases. Show your work.

Part 5 - Best Predicted Value

Between the predicted value of y and the mean value ofy , 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 about250,000.

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 PASTETHE 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 about250,000.

From the updated data values on your spreadsheet, create a scatter plot. 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 PASTETHE 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 about250,000.

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

Write the value of thecorrelation coefficient without rounding:

r=

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 about250,000.

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:

1. let represent the number of cases
   • using the code "=AVERAGE(A2:A11)" in your spreadsheet, compute

x=

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

sx=

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

y=

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

sy=

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

a=

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

b=

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

1. Use the regression line equation and computey, the predicted number of deaths, if a state reaches6,000,000 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 about250,000.

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