1. Manually do the following steps using the appropriate formula. SHOW YOUR WORK! WRITE THE FORMULAS AND SHOW YOUR WORK STEP BY STEP. USE ONY the formulas in the FORMULA SHEET!

a. Develop the estimated regression equation by using the formula for computing the values for bo and b1.

b. Compute SSE, SST, and SSR using only Computing formulas.

c. Compute the coefficient of determination r (The same as R ). Comment on the goodness of fit (That is, what does the value of r tell you about the goodness of the fit). Explain why.

d. Compute the sample correlation coefficient (r).

e. Determine if the slope is significant at Alpha = 0.05ant

y	6	6	4	4	2	0	-1
x	1	2	3	4	5	6	7

2. Run the regression model in Excel above.