Question

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. where high-school grade point average SAT mathematics score 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 SS MS F Significance F Regression 2 .8811 52.4464 Residual 7 .1179 .0168 Total Coefficients Standard Error t Stat P-value Intercept X1 X2
b. Using , test for overall significance.
c. Did the estimated regression equation provide a good fit to the data

Answer 1

Answer:

A. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. ANOVA df SS MS F Significance F Regression 2 .8811 52.4464 Residual 7 .1179 .0168 Total Coefficients Standard Error t Stat P-value Intercept X1 X2.