(Solved): (a) Make an Excel worksheet to calculate SSyx,SSyy, and SSxy. (Leave no cells blank-be ce ...

(a) Make an Excel worksheet to calculate $S{S}_{yx},S{S}_{yy}$, and $S{S}_{xy}$. (Leave no cells blank-be certaln to enter "o" wherever required. Negative values should be Indicated by a minus sign. Round your answers to 2 decimal places-] (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) (c) Use your estumated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no calls blank - be certaln to enter " $O$ " wherever requlred. Negatlve values should be Indlceted by a minus sign. Do not round Intermedlate calculatlons, but flnal answers should be rounded to 3 decimal places.) (d) Calculate the $R^2$ (Round your answer to 4 decimel pleces.)