Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A researcher is interested in the relationship between the average lockdown time (days) a city has endured during the COVID-19 pandemic and the selling price
A researcher is interested in the relationship between the average lockdown time (days) a city has endured during the COVID-19 pandemic and the selling price ($) of a dog. He took a random sample and used EXCEL to create the following simple linear regression.
SUMMARY OUTPUT Regression Statistics Multiple R 0.95 R Square 0.91 Adjusted R Square 0.90 Standard Error 699.56 Observations 13 ANOVA df SS MS F Significance F Regression 1 53956644.00 53956644.00 110.25 0.00 Residual 11 5383248.31 489386.21 Total 12 59339892.31 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -417.62 303.34 -1.38 0.20 -1085.27 250.03 Average lockdown time 22.41 2.13 10.50 0.00 17.72 27.11Step 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