# A portion of the Excel Regression tool output follows. 1 answer below »

• September 24, 2021 /

Recall that in 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.

Don't use plagiarized sources. Get Your Custom Essay on
A portion of the Excel Regression tool output follows. 1 answer below »
Just from \$13/Page = -1.41 + .0235x1 + .00486x2

x1 = high-school grade point average

x2 = SAT mathematics score

= final college grade point average

A portion of the Excel Regression tool output follows.

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

a. Complete the missing entries in this output.

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

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

d. Use the test and α = .05 to test H0β1 = 0 and H0β2 = 0.