42. Recall that in exercise 39, the admissions officer for Clearwater College developed the fol- lowing estimated regression equation relating final college GPA to the student's SAT mathe- matics score and high-school GPA. = -1.41 + .0235x + .00486x where x, high-school grade point average SAT mathematics score y final college grade point average A portion of the Excel Regression tool output follows.

a. Complete the missing entries in this output.

b. Using a = .05, test for overall significance.

c. Did the estimated regression equation provide a good fit to the data? Explain.

d. Use the r test and a=.05 to test H: B = 0 and Ho: B = 0.

Transcribed Image Text:

123 SUMMARY OUTPUT Regression Statistics 4 Multiple R 5 R Square 6 Adjusted R Square 7 Standard Error 8 9 Observations 10 ANOVA 11 12 Regression 13 Residual 14 Total 15 16 17 Intercept 18 XI 19 X2 20 B D E F G df SS MS F Significance F 1.76209 9 1.88 Coefficients Standard Error -1.4053 0.023467 0.4848 0.0086666 0.00486 0.001077 1 Stat P-value