Question

22 26 of 3 is to 2

Answer 1

			Sxx	Syy	Sxy
	x	y	(X-Xbar)2	(Y-Ybar)2	(X-Xbar)(Y-Ybar)
	26	80	1369	102400	11840
	45	344	324	3136	1008
	54	416	81	256	-144
	49	348	196	2704	728
	35	166	784	54756	6552
	41	220	484	32400	3960
	41	262	484	19044	3036
	49	360	196	1600	560
	38	204	625	38416	4900
Total	378	2400	4543	254712	32440
Mean	63	400
beta1	7.14
beta0	-49.86

The equation of regression line is

y=beta0 + beta1 x

y = -49.86 + 7,14 x

Formula Sheet

			Sxx	Syy	Sxy
	x	y	(X-Xbar)2	(Y-Ybar)2	(X-Xbar)(Y-Ybar)
	26	80	=(B3-$B$13)^2	=(C3-$C$13)^2	=(B3-$B$13)*(C3-$C$13)
	45	344	=(B4-$B$13)^2	=(C4-$C$13)^2	=(B4-$B$13)*(C4-$C$13)
	54	416	=(B5-$B$13)^2	=(C5-$C$13)^2	=(B5-$B$13)*(C5-$C$13)
	49	348	=(B6-$B$13)^2	=(C6-$C$13)^2	=(B6-$B$13)*(C6-$C$13)
	35	166	=(B7-$B$13)^2	=(C7-$C$13)^2	=(B7-$B$13)*(C7-$C$13)
	41	220	=(B8-$B$13)^2	=(C8-$C$13)^2	=(B8-$B$13)*(C8-$C$13)
	41	262	=(B9-$B$13)^2	=(C9-$C$13)^2	=(B9-$B$13)*(C9-$C$13)
	49	360	=(B10-$B$13)^2	=(C10-$C$13)^2	=(B10-$B$13)*(C10-$C$13)
	38	204	=(B11-$B$13)^2	=(C11-$C$13)^2	=(B11-$B$13)*(C11-$C$13)
Total	=SUM(B3:B11)	=SUM(C3:C11)	=SUM(D3:D11)	=SUM(E3:E11)	=SUM(F3:F11)
Mean	=B12/6	=C12/6
beta1	=F12/D12
beta0	=C13-B14*B13

beta1=Sxy/Sxx

beta0= mean(y) - beta1 * mean(x)