For the table below, find the following: 1. Manually do the following steps using the appropriate...

Transcribed Image Text:

For the table below, find the following: 1. Manually do the following steps using the appropriate formula. SHOW YOUR WORK! y X a. Develop the estimated regression equation by using the formula for computing the values for ba and b₁. b. Compute SSE, SST, and SSR using only Computing formulas. c. Compute the coefficient of determination r²(The same as R2). Comment on the goodness of fit (That is, what does the value of r² tell you about the goodness of the fit). Explain why. Compute the sample correlation coefficient (r). d. e. Determine if the slope is significant at Alpha=0.05. Include graphs where-ever and if applicable. 2. Run the regression model in Excel and submit online. 9 1 7 2 5 3 3 4 0 5 -4 6 -6 7 For the table below, find the following: 1. Manually do the following steps using the appropriate formula. SHOW YOUR WORK! y X a. Develop the estimated regression equation by using the formula for computing the values for ba and b₁. b. Compute SSE, SST, and SSR using only Computing formulas. c. Compute the coefficient of determination r²(The same as R2). Comment on the goodness of fit (That is, what does the value of r² tell you about the goodness of the fit). Explain why. Compute the sample correlation coefficient (r). d. e. Determine if the slope is significant at Alpha=0.05. Include graphs where-ever and if applicable. 2. Run the regression model in Excel and submit online. 9 1 7 2 5 3 3 4 0 5 -4 6 -6 7

Answer rating: 100% (QA)

a Develop the estimated regression equation by using the formula for computing the values for ba and b The estimated regression equation is b bx To compute the values for b and b we need to use the fo... View the full answer