Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4 (25 points) In a simple linear regression task that regresses variable Y on variable X, Excel produces the following table with certain numbers
4 (25 points) In a simple linear regression task that regresses variable Y on variable X, Excel produces the following table with certain numbers masked by (a)-(j). Multiple R 0.47240466 R Square 0.223166163 Adjusted R Square 0.180008727 Standard Error 26.39344634 Observations 20 ANOVA df SS MS F Regression (a) 3602.175938 (e) (g) Significance F (h) Residual (b) (d) (f) Total (c) 16141.22812 Coefficients Standard Error Intercept X -14.44449679 2.327403257 12.26058606 t Stat P-value -1.178124497 0.254088 1.023493949 (i) Lower 95% -40.20303227 Upper 95% 11.31403869 (i) 0.177122261 4.477684254 (a) Reproduce the numbers masked by (a)-(j) using the existing information in the table. (b) What is the regressed equation? (c) Is the model significant at the significance level = 0.05? (d) What is the correlation coefficient of X and Y? (e) For the test Ho B1 1.5, should we reject Ho at the significance level a = 0.05?
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