The data in the table is the number of absences for 77 students and their corresponding grade.
| Number of Absences | 2 | 4 | 4 | 5 | 6 | 7 | 7 |
|---|---|---|---|---|---|---|---|
| Grade | 3.7 | 3.5 | 3.4 | 3.2 | 3 | 2.4 | 2 |
Step 2 of 5 :
Calculate the estimated variance of errors, s2e. Round your answer to three decimal places.
Using Excel
regression result
| SUMMARY OUTPUT | |||||
| Regression Statistics | |||||
| Multiple R | 0.915277826 | ||||
| R Square | 0.837733499 | ||||
| Adjusted R Square | 0.805280199 | ||||
| Standard Error | 0.272868362 | ||||
| Observations | 7 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 1 | 1.922 | 1.922 | 25.81350729 | 0.003832172 |
| Residual | 5 | 0.372285714 | 0.074457143 | ||
| Total | 6 | 2.294285714 | |||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
| Intercept | 4.578571429 | 0.322037518 | 14.21750935 | 3.10054E-05 | 3.750747633 |
| Number of Absences | -0.31 | 0.061015221 | -5.080699488 | 0.003832172 | -0.466844618 |
estimated variance of errors
= MSE
= 0.074457143
= 0.074
Get Answers For Free
Most questions answered within 1 hours.