# E MINDTAP Q Search this c Assignment eBook 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. ŷ = -1.4053 +.02351 +.0049r2 where I1 = high-school grade point average T = SAT mathematics score y = final college grade point average Round your answers to 4 decimal places. a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. ANOVA df Significance F MS Windows 1.7621 Regression 52.29 0.9681 0.88105 5, y = final college grade point average Round your answers to 4 decimal places. a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. ANOVA df Significance F SS MS Regression 1.7621 52.29 2. 0.88105 0.9681 Residual 0.01685 0.11794 1.88 9. Total P-value t Stat Standard Error Coefficients 0.24 0.4848 -2.90 -1.4053 Intercept 0.0302 0.0087 2.71 0.0235 X1 0.003 0.0011 4.51 0.0049 X2 .05, test for overall significance. b. Using a= 12:03 1/26/2

Question

The admission officer for Clearwater College developed the following estimated regression equation relating tge funal college GPA to the students SAT mathematics score and high school GPA.

Y = -1.4053 + 0.235x1 + .0049x2

X1 = high school grade point average

X2 ,= SAT mathematics score

Y= final collage grade point average

Round your answers  to 4 decimal places.

A. Complete the missing entries  in this excel regression tool output. Enter negative values aa negative numbers.

Significance F ?

T stat x2?

Thank you