Question

(a) Make a worksheet to calculate SS SSyy, and SSxy. (Leave no cells blank. Each cell will be a whole number. No decimals are required. Be certain to enter "0" wherever required.) Hours Worked (X) Part-Time Weekly Earnings ($) by College Students Weekly Pay (V) (x - 3) xị - x) (y -ỹ) 110 200 230 180 280 (b) Use the formulas to calculate the slope and intercept. (Each answer will be a whole number. No decimals are required.)

Answer 1

Answer : Here n= 5 Hours Weekly worked (X)_payers exi-1² (y; - 7,² cai - (yi-4) 8100 - goo 110 200 230 180 280 --- O o goo 400 6400 225 1200 sum 100 1000 350 2100 (E) 15800 10 200 350 Į Ssaa 15800 Ssyy 2100 ssay ssoa The formulas - = E 9 = ssar = are = 100 - 20 – 1000 - 200 caicā? = 350 1000 5 Ssyy = z cyi-9)2 = 15800__ Ssay = Ecaj- a cyi- 9) = 2100 by formulas to calculare slope_ and _jntercep! Saa bi = SSay - 2100 = 6 tie bi= 6 350 bor Ý - bi as 200 - 6X20 = 80 lbo= 80 ABHIJEET

DATEJ Haus workel (221) Weekly Pay(yi) ý = botbiai Estimulee Pay C9 ) yi -ý (9- )? chi – 9j(91-9 - is 20 20 110 200 230 180 280 1000 formulas 140 170 200 200 290 1000 are -30 30 30 -20 -10 o goo 3600 800 goo goo gooo goo 400 o 400 100 8100 6400 - 3200 12600 15800 sums) 100 The a = ?X = 20 ġ - EY - 200 SSL = 5( gì - 1)^ = SSR = EC - )? = 3200 12600 SST = E cyi - ģ)? = 15 800 The formula Pue R² is SSR R= SSR = 12600 2.600 SST 15800 R² = 0.7974 R? = 0.79 7.