Regression analysis

Professors Han and Groman dabble in chemical engineering in their spare time. They have developed a plastics additive($2009) that will make super balls bounce even higher. They believe this new additive may even have application in the space program. For example, if the shuttle were coated in it, space junk would simply bounce off. Han and Groman have tested the performance of their $2009additive by varying the amount they mix in plastic, molding the plastic into 0.5 in. diameter balls, then measuring how high (in feet) each ball bounces when dropped from a height of 3 feet. They conducted their test on 60 different balls (one each for 60 different additive levels), and used regression analysis to estimate the relationship between bounce, the dependent variable, and 52009, the independent variable, as reflected in the following model: Bounce; = Bo + B1 S2009; + A partial output of the regression is given below. Find C and J and please explain in SUMMARY OUTPUT detail how did you get to the answer. Please provide excel formula if applies Regression Statistics Multiple R 0.6121 Something like t.dist.2t or t.dist.t R Square K Adjusted R Square Standard Error 5.4414 Observations 60 ANOVA df 55 MS F ignificance Regression H 34.7451 Residual F 1717.3069 29.6087 Total G 2746.0660 Coefficients Standard Error t Stat P-value Lower 95% Intercept 1.0260 0.7044 A B $2009 1.1251 0.1909 D E What would you conclude from the F-test for this output? Recall that the p-value of the F-test appears in the box marked J. There is only one independent variable, so the F-test reproduces something you have already done. Reject the hypothesis that the coefficient for $2009 is zero at the 1% level of significance, since the p-value is greater than 0.0 Reject the hypothesis that the coefficient for $2009 is zero at that 1% level of significance, since the p-value is less than 0.01 Do not reject the hypothesis that the coefficient for $2009 is zero at that 1% level of significance, since the p-value is less than 0.01 Do not reject the hypothesis that the coefficient for $2009 is zero at the 1% level of significance, since the p-value is greater than 0.01