Question

For the table below, find the following: 0 0 13 Manually do the following steps using the appropriate formula SHOW YOUR WORK Develop the estimated regression equation by using the formula for computing the values for b, and b, SHOW YOUR WORK" means wRITE the formula and create the columns as needed below follow the steps through. If you need more space below, create them by pressing ENTER Compute SSE, SST, and SSR using only Computing formulas. 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 Compute the sample correlation coefficient (r). (Hint: You do not need to use the formula for r!) Determine if the slope is significant at Alpha-0.05ant Run the regression model in Excel and submit in the related link. -3 0 13 7 5 0 6

Answer 1

Answer:

2 9-1-0-0-4 9-1-0-0 8-3-0 0-0 7-5 0-0-7-5

Equation of regression line is Y -abX b = (7 * 151-21 * 28)/(7 * 253-21)2) b 0.3526 as(28-(0.3526 * 21 ) ) / 7 a = 2.9421 Equation of regression line becomes Y = 2 . 9421 Sxx 190 Syy 28 SXY = 67 0 . 3526X ((7 * 151)-21 * 28)/(V(7 * 253) _ (21)2)(7 * 140)-(28)2) r 0.9186 R-,2 = (0.9186)-0.8438

To Test:- Test Statistic:- t (0.3526-0)/(0.9355/V190) t5.1954 Test Criteria: Reject null hypothesis ifa,n-2 a/2,n-2 -to.o5/2,7-2-3.1634 > ta/2,n-2 5.1954 > 3.1634 Result:- Reject null hypothesis Decision based on P value P - value-P (t>5.1954)- 0.0035 Reject null hypothesis if P value <a0.05 level of significance P - value 0.0035< 0.05 ,hence we reject null hypothesis Conclusion:- Reject null hypothesis Accept H1 i.e b 0 The slope is significant at 5% level of significance