(Solved) Recall that in exercise 49, the admissions officer for Clearwater College developed the following estimated regression equation relating final
Question: Recall that in exercise 49, the admissions officer for Clearwater College developed the following estimated regression equation relating final college GPA to the student’s SAT mathematics score and high-school GPA.
= -1.41 + .0235
+ .00486
where
= high-school grade point average
= SAT mathematics score
y = final college grade point average
A portion of the Minitab computer output follows.
The regression equation is
Y = -1.41 + .0235 X1 + .00486 X2
Predictor Coef SE Coef T
Constant -1. 4053 0.4848 __ -2.899 ___
X1 0.023467 0.008666 __ 2.708 ___
X2 0.0 0 486 ____ 0.001077 ___ 4.513 __
S = 0.1298 R–sq = ___ 0.9373___ R–sq( adj ) = ___ 0.919386___
Analysis of Variance
SOURCE DF SS MS F
Regression __ 2 ___ 1.76209 0.881045 ____ __ 52.3053 ___
Residual Error ___ 7 __ 0.11791 0.016844286 ____ _____
Total 9 1.88000
- Compute the missing entries in this output.
- Use the F test and α = .05 to see whether a significant relationship is present.
-
Use the t test and α= .05 to test
:
= 0 and
:
= 0
- Did the estimated regression equation provide a good fit to the data? Explain.
Deliverable: Word Document 