(Choose 1 answer)
(See picture)
A. 3.12
Β. 2.61
C. 2.66
D. 2.80
It is believed that GPA (grade point average, based on a four point scale) should have a positive linear relationship with ACT scores.Given below is the Excel output for predicting GPA using ACT scores based a data set of 8 randomly chosen students from a Big-Ten university.
Regressing GPA on ACT
Regression Statistics
Multiple R
0.7598
R Square
0.5774
Adjusted R
Square Standard Error
0.5069
0.2691
Observations
8
ANOVA
df
SS
MS
Significance F
F
Regression
1
0.5940 0.5940 8.1986 0.0286
Residual Total
6
0.4347 0.0724 1.0287
7
Standard
Intercept ACT
Coefficients Error 1 Stat
P-value
Lower 95%
Upper 95%
0.5681
0.1021
0.9284 0.6119 0.5630 -1.7036
0.0356 2.8633 0.0286
0.0148
2.8398
0.1895
Use the above information to find the predicted value of GPA when
Q: 46
