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 |
Construct the 99% confidence interval for the slope. Round your answers to three decimal places.
lower endpoint=
upper endpoint =
For the given data using REGRESSION in Excel we get output as
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.81351 | 0.003832172 | |
Residual | 5 | 0.372285714 | 0.074457 | |||
Total | 6 | 2.294285714 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 4.578571429 | 0.322037518 | 14.21751 | 3.1E-05 | 3.750747634 | 5.406395223 |
Number of Absences | -0.31 | 0.061015221 | -5.0807 | 0.003832 | -0.466844618 | -0.15315538 |
Get Answers For Free
Most questions answered within 1 hours.