8. Please answer the questions using the data in the table below. X1 24.9 66.3 1

Question

8. Please answer the questions using the data in the table below. X1 24.9 66.3 13.5 3.7 59.8 26.7 100.6 30.6 77.8 13.8 15.7 76.5 39.6 834 8.8 8 33.1 694 10.6 18.3 81.9 41.1 83.5 9.7 21.8 84.6 25.4 112.7 9.8 16.4 87.3 33.8 688 6.8 25.9 88.5 23.5 69.57.5 15.5 90.7 39.8 63.0 6.8 30.8 93.4 (a) Use technologytofind he multiple regression cquation for the data s for the data shown in the table (b) Find the standard error of estimate and interpret the result. (c) Find the coefficient of determination and interpret the result.

Explanation / Answer

(a)

Following is the output of multiple regression analysis generated by excel:

(B)

The standard error of estimate is: 4.198

It shows that the variation between the predicted values by model is 4.198.

(c)

The coefficient of determination is: 0.9166

It shows that 91.66% of variation in depedent variable is explained by independent variable.

SUMMARY OUTPUT Regression Statistics Multiple R 0.957409454 R Square 0.916632862 Adjusted R Square 0.849939151 Standard Error 4.198130123 Observations 10 ANOVA df SS MS F Significance F Regression 4 968.9075174 242.2268793 13.7439176 0.006605291 Residual 5 88.12148265 17.62429653 Total 9 1057.029 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 89.29799505 13.44181803 6.64329742 0.001165029 54.7447018 123.8512883 X1 -0.26192069 0.248892427 -1.052344964 0.340817389 -0.901719044 0.377877659 X2 0.132705768 0.093451248 1.420053455 0.214827149 -0.107518313 0.372929849 X3 -2.25880014 0.609424322 -3.706448947 0.013906023 -3.825375231 -0.692225045 X4 0.734979909 0.243420819 3.019379821 0.02943727 0.109246773 1.360713045

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.