The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1) is the number of hours spent studying, and the second independent variable (x2) is the student's GPA.
Study hours | GPA | ACT score |
0 | 2 | 17 |
1 | 2 | 19 |
5 | 2 | 28 |
5 | 3 | 29 |
6 | 4 | 31 |
Find the p-value for the regression equation that fits the given data.
How do i find p value on a ti-84 calc? i dont have excel.
Regression Statistics | |||||
Multiple R | 0.9991 | ||||
R Square | 0.9982 | ||||
Adjusted R Square | 0.9963 | ||||
Standard Error | 0.3851 | ||||
Observations | 5 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 2 | 160.50 | 80.25 | 541.13 | 0.0018 |
Residual | 2 | 0.30 | 0.15 | ||
Total | 4 | 160.80 | |||
Coefficients | Standard Error | t Stat | P-value | ||
Intercept | 16.08 | 0.62 | 25.81 | 0.0015 | |
Study hours | 2.25 | 0.10 | 22.40 | 0.0020 | |
GPA | 0.42 | 0.30 | 1.37 | 0.3040 |
The p-value for the regression equation is 0.0018
In excel, I have used the Regression function in the Data Analysis option of the Data tab.
Get Answers For Free
Most questions answered within 1 hours.