Homework SourseSolve for the predicted values of y and the residuals for th
Solve for the predicted values of y and the residuals for the following data.
x 12 21 28 8 20
y 17 15 22 19 24
Do not round the intermediate values. (Round your answers to 3 decimal places.)
Solution
Sol)
From Excel
The fitted model is y= 16.51 + 0.16 X
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.351156 | |||||
| R Square | 0.123311 | |||||
| Adjusted R Square | -0.16892 | |||||
| Standard Error | 3.942921 | |||||
| Observations | 5 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 6.560129 | 6.560129 | 0.421965 | 0.562261 | |
| Residual | 3 | 46.63987 | 15.54662 | |||
| Total | 4 | 53.2 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 16.50965 | 4.786181 | 3.449441 | 0.040953 | 1.277883 | 31.74141 |
| X | 0.162379 | 0.249973 | 0.649588 | 0.562261 | -0.63315 | 0.957905 |
