Recall that in exercise 44, 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 + .0235x₁ +.00486x₂

where

x₁ = high-school grade point average

x₂ = SAT mathematics score

y = final college grade point average

A portion of the regression output follows.

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 t test and α = .05 to test H₀: β₁ = 0 and H₀: β₂= 0.

Transcribed Image Text:

Exercise 47-Microsoft Exoel Home Insert Page Layout Formulss Dsta Review View Add-hs StatTools SUMMARY OUTPUT SUMMARY OUTPUT Regression Statistics 4 Multiple R 5 R Square 6 Adjusted R Square 7 Standard Error 8 Observations 0 10 ANOVA sS MS F SignsficanceF 12 Regression 13 Residual 14 Total 13 16 17 Intercept 18 X1 1.76209 1.88 Coefficients Standard Error tStat P-value -1.4053 0.023467 0.00486 0.4848 0.0086666 0.001077 20 Ready 熙ー凹100%