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 j--1.4053 .0235xi +.0049x2 where #1-high-school grade point average 2-SAT mathematics score yfinal 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 NOVA df MS Significance F Regression 1.7621 Residual otal 1.8 Coefficients Standard Error t Stat P-value 1.4053 0.0235 0.0049 0.4848 0.0087 0.0011 ntercept X2 b. using α = .05, test for overall significance. - Select your answer- c. Did the estimated regression equation provide a good fit to the data? Explain. -Select your answer- d. Use the t test and α-.05 to test Ho : A 0 and Ho : A 0 . Use t table. The input in the box below will not be graded, but may be reviewed and considered by your instruction. blank

Answer 1

a) From the given information n-19 n=10 So MSR 0.8810 MSE 0.0168 Hence F- MSR/MSE -0.8810/0.0168 -5244 It is clear that F-F=(2,7) From the F distribution P value 0.000061 Thus the ANOVA table as follows soure ofdegreessum mea sum F freedom of squires of squires Regression2 Residuel Total 52440.000061 1.7621 0.1179 1.88 0.8810 0.0168 For the value of intercept t=-1.4053/0.4848 28987 The value of P using t (-2.8987) 0.017624 For the value of X1 t 0.0235/0.0087 -2.7011 The value of P using t 27011)-0.02435 For the value of X2 t-0.0049/0.0011 -44545 The value of P using t(4.4545)-0.00159 b)State the hypothesis From the above test statistic value is 5244 and c P value is 0.000061

Results are as follows fromm where round off as per questions Significance F 0.000062 t-stat slope/SE 2898721122 2.701149425 4.454545455 p-value 0.023027897 0.030588112 0.002955407

b) p-value = 0.000 < α= 0.05 Hence, thereexists significant relationship c) Yes. The estim ated regressi on equation provide a good fit to the data d) -2.7011 and p-value-0.0243a, Hence, reject H and p-value 0.0243 c pid 4545 and p-value-0 0016-a, Hence, reject Ho