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.