The admissions officer for Clearwater College developed thefollowing estimated regression equation relating final college GPAto the student's SAT mathematics score and high-school GPA. Round your answers to 4 decimal places.
a. Complete the missing entries in thisExcel Regression tool output
ANOVA
df SS MS F Significance F
Regression 1.7621
Residual
Total 9 1.88
Coefficients Standard Error t Stat P-value
Intercept -1.4053 0.4848
X1 0.0235 0.0087
X2 0.0049 0.0011
b. Using α = .05, test for overallsignificance.
SelectThere exists significant relationship. There exists no significant relationship. This question is unanswered
c. Did the estimated regression equationprovide a good fit to the data? Explain.
SelectYesNoThis question is unanswered
d. Use the t test and α = .05 totest H0:β1 = 0 andH0:β2 = 0.