Question: Please use excel SUMMARY OUTPUT Regression Statistics Multiple R 0.37276112 R Square 0.13895085 Adjusted R Square 0.14763528 Standard Error 204.846855 Observations 18 ANOVA Significance 2.581982277


Please use excel
SUMMARY OUTPUT Regression Statistics Multiple R 0.37276112 R Square 0.13895085 Adjusted R Square 0.14763528 Standard Error 204.846855 Observations 18 ANOVA Significance 2.581982277 Regression Residual Total 0.127639 MS 108345.7 41962.23 1 16 17 SS 108345.7 671395.7 779741.5 Coefficients -46.019393 Standard Error 3.360904 2.585766 Stat -13.6926 -1.60685 Intercept X Variable P-value 2.97523E-10 0.127638676 Upper 95% -38.8946 1.326629 Lower 95% -53.1442 -9.63653 Lower 95.0% -53.1442 -9.63653 Upper 95.0% -38.8946 1.326629 Given the regression table above, answer the following questions: Is relationship direct or inverse? (Input 1-Direct or 2 - Inverse) What is the intercept rounded to 2 decimal places? Given the regression table above, answer the following questions: Is relationship direct or inverse? (Input 1=Direct or 2 = Inverse) What is the intercept rounded to 2 decimal places? What is the slope rounded to 2 decimal places? What is the coefficient of correlation rounded to 4 decimal places? What is the p-value that would be used to test for linearity round to 4 decimal placesStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
