The admissions officer for Clearwater College developed the following estimated regression equation relating the final college G
PA 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
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.
it says it already a function so your just plotting (-4,10) (0,8) (4,6) (10,3) on a graph, there isnt a graph to do it for you. Sorry if im reading this wrong :(
