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. y = -1.4053+.0235x1 +.004922 where 21 = high-school grade point average 22 = 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 SS MS F Significance F Regression 1.7621 Residual Total 9 1.88 Coefficients Standard Error t Stat P-value Intercept -1.4053 0.4848 X1 0.0235 0.0087 X2 0.0049 0.0011 b. Using a = .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 -

Answer choices for. part - B are

There. exists significant relationships

There exists NO significant relationships

Answer choices for Part C are

Yes

No

Answer 1

	df	SS	MS	F	Significance F
Regression	2	1.7621	0.8811	52.3100	0.0001
Residual	7	0.1179	0.0168
Total	9	1.8800
	Coefficients	Standard Error	t Stat	P-value
Intercept	-1.4053	0.4848	-2.8987	0.0230
x1	0.0235	0.0087	2.7011	0.0306
x2	0.0049	0.0011	4.4545	0.0030

b)

There. exists significant relationships

c)

R2 =SSR/SST =1.7621/1.8800=			0.9373
93.73% of variation is explained by model which is significantly high. therefore model is a good fit

Yes