(a) Make an Excel worksheet to calculate SSxx, SSy, and SS. (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.) & Click here for the Excel Data File Part-Time Weekly Earnings ($) by College Students Hours Worked Weekly Pay (Y)| (x; - xbar)2 (yi - ybar) (x; - xbar)(y; - ybar) (X) 9 103 14 173 22 216 18 153 36 260 xbar ybar S5xx SSy SSxy (b) Use the formulas to calculate the slope and Intercept (Round your answers to 3 decimal places.) bo(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 "O" 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 Weekly Pay Estimated Pay (x; ) (v;) vi - y (vi - y;)2 (vi - ybar)2 (vi - ybar) 9 103 14 173 22 216 18 153 36 260 xbar ybar SSE SSR SST (d) Calculate the R. (Round your answer to 4 decimal places.) R2