Question

(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Picture Click here for the Excel Data File Part-Time Weekly Earnings ($) by College Students Hours Worked (X) Weekly Pay (Y) formula31.mml(x i −x ¯ ) 2 (xi−x¯)2 formula32.mml(y i −y ¯ ) 2 (yi−y¯)2 formula33.mml(x i −x ¯ ) (y i −y ¯ ) (xi−x¯) (yi−y¯) 9 98 12 186 16 203 18 159 35 263 formula34.mmlx ¯ x¯ formula35.mmly ¯ y¯ formula36.mmlss xx ssxx formula37.mmlss yy ssyy formula38.mmlss xy ssxy (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) b1 b0 (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calculations, but final answers should be rounded to 3 decimal places.) Hours Worked (xi) Weekly Pay (yi) Estimated Pay formula229.mml(y ˆ i ) (y^i) formula230.mmly i −y i ˆ yi−yi^ formula231.mml(y i−y ˆ i ) 2 (yi−y^i)2 formula232.mml(y ˆ i −y ¯ ) 2 (y^i−y¯)2 formula233.mml(y i −y ¯ ) 2 (yi−y¯)2 9 98 12 186 16 203 18 159 35 263 formula234.mmlx ¯ x¯ formula235.mmly ¯ y¯ SSE SSR SST (d) Calculate the R2. (Round your answer to 4 decimal places.) R2

Answer 1

s.no	x	y	(x-X)2	(y-Y)2	(x-X)(y-Y)
1	9	103	116.6400	6084..0000	842.4000
2	14	173	33.6400	64.0000	46.4000
3	22	216	4.8400	1225.0000	77.0000
4	18	153	3.2400	784.0000	50.4000
5	36	260	262.4400	6241.0000	1279.8000
6	19.80	1810	420.8000	14398.0000	2296..0000
mean	xbar	ybar	SSX	SSY	SXY

b) b1=5.456

b0=72.966

c)

hours worked(xi)	weekly pay(yi)	estimated pay(y^i)	yi-yi^	(yi-y^i)2	(y^i-y??)2	(yi-y??)2
9	103	122.07	-19.07	363.6649	3472..745	6084
14	173	149.35	23.65	559..3225	1001.723	64
22	216	192.998	23..002	529.092	143.952	1225
18	153	171.174	-18..174	330.2943	96.55028	784
36	260	269.382	-9.382	88.02192	7811.378	6241

xbar=19.8

ybar=181

SSE=1870.396

SSR=12526.348

SST=14398

d) R^2=0.8700