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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 08, 2024

PROBLEM 1 (There are 5 parts in this problem) Part 1 - Organizing Data Values You will be using Coronavirus data from the webpage Worldometer

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.