Chapter 15, Problem 47SE

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.

$\hat{y}=-1.41+.0235x_1+.00486x_2$

where

x₁ = high-school grade point average

x₂ = SAT mathematics score

y = final college grade point average

A portion of the Excel Regression tool output follows.

1. a. Complete the missing entries in this output.
2. b. Using α = .05, test for overall significance.
3. c. Did the estimated regression equation provide a good fit to the data? Explain.
4. d. Use the t test and α = .05 to test H₀: β₁ = 0 and H₀: β₂ = 0.

44. The admissions officer for Clearwater College developed the following estimated regression equation relating the final college GPA to the student’s SAT mathematics score and high-school GPA.

$\hat{y}=-1.41+.235x_1+.00486x_2$

where

x₁ = high-school grade point average

x₂ = SAT mathematics score

y = final college grade point average

1. a. Interpret the coefficients in this estimated regression equation.
2. b. Predict the final college GPA for a student who has a high-school average of 84 and a score of 540 on the SAT mathematics test.