Question
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
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 250,000.
use this link https://www.worldometers.info/coronavirus/country/us/
You will be using the same Coronavirus data use link: replace the number of deaths in the state of New York with 250,000.
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
In your spreadsheet (Excel or Google Sheets) show a scatter plot. Copy and paste the scatter plot onto your word processor (Word or Google Docs), right after the table of data values.
describe your scatter plot. does it 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 or strong, positive or negative, and explain your reasoning;
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. S. state for that outlier.
Part 2 -Correlation Coefficient
In your spreadsheet (Excel of Google Sheets), compute the correlation coefficient rusing the appropriate codes.
Write the value of r in your word processor (Word or Google Docs) without rounding.
Analyze the correlation coefficient r 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 rshows a positive or negative linear correlation, and explain your reasoning.
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 top 10 states with the new number of deaths for New York.
use link https://www.worldometers.info/coronavirus/country/us/
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
- The sample mean x using the code "AVERAGE(A2:A10)" in your spreadsheet;
- The sample standard deviationjQuery2240754778362573505_1620677378427 using the code "=STDEV.S(A2:A10)" in your spreadsheet;
B). let y represent the number of deaths and compute
- The sample mean y using the code "=AVERAGE(B2:B10)" in your spreadsheet;
- The sample standard deviation ?? using the code "=STDEV.S(B2:B10)" in your spreadsheet;
C). compute the slope ? using the appropriate formula (show your work);
D). compute the y-intercept ? using the appropriate formula (show your work);
E). write the regression line equation = ax + ? by replacing ? and ? with the computed values
F). use the regression line equation to compute the predicted number of deaths when a state has x = 4, 000,000 cases;
G). indicate which value, between and , is the best predicted number of deaths for a state with x = 4, 000, 000 cases, and explain your reasoning.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started