a Make an Excel worksheet to calculate SSxx SSyy and SSxy Le

(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.) (b) Use the formulas to calculate the slope and intercept (Round your answers to 3 decimal places.) (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 indicated by a minus sign. Do not round intermediate rounded to 3 decimal places.) (d) Calculate the R^2. (Round your answer to 4 decimal places.)

Solution