Question

This problem is based on problems 18.1, 18.2, 18.9, & 18.10 from Lomax & Hahs-Vaughn, 3rd ed. You are given the following data, where Xi (final percentage in history class) and X2 (number of absences) are used to predict Y (standardized history test score in fourth grade) 485 99 465 92 370 75 415 95 410 72 350 78 390 80 480 98 400 82 450 89 350 70 420 80 Determine the following multiple regression values. Report intercept and slopes for regression equation accurate to 3 decimal places: Intercept: a- Partial slope Xi: bi- Partial slope X2: b2 - Report sum of squares accurate to 3 decimal places SSres Test the significance of the overall regression model (report F-ratio accurate to 3 decimal places and P-value accurate to 4 decimal places): -ratio P-value- Report the variance of the residuals accurate to 3 decimal places sres Report the test statistics for the regression coefficients accurate to 3 decimal places:

Answer 1

excel steps for regression

write data>menu>data>data analysis>regression>enter required labels>ok

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.884925
R Square	0.783092
Adjusted R Square	0.73489
Standard Error	24.16184
Observations	12
ANOVA
	df	SS	MS	F	Significance F
Regression	2	18968.77	9484.383	16.2461	0.001031
Residual	9	5254.15	583.7945
Total	11	24222.92
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	170.4518	79.22243	2.151559	0.059884	-8.76182	349.6654	-8.76182	349.6654
X1	3.121937	0.862962	3.617701	0.005592	1.169783	5.074092	1.169783	5.074092
X2	-11.241	6.651015	-1.69011	0.125268	-26.2866	3.804688	-26.2866	3.804688

from given o/p

a = 170.452

b1 = 3.122

b2 = -11.241

SSreg = 18968.767

SSres = 5254.150

F-ratio=16.246

p-value=0.001

s²res = 583.794

t1 =3.618

t2 = -1.690