Question

CENGAGE MINDTAP Q Search this cours pter 15 Assignment eBook The admissions oficer 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 +.023521 +.004922 where *1 = high-school grade point average 2y = 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 Significance F Regression 1.7621 Residual Total 9 1 .88 Pevalue Intercept Coefficients -1.4053 0.0235 Standard Error Stat 0.4848 0.0087 LDL 0.0011 0.0049

Answer 1

from given data:

	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