Question: Suppose that you have been asked to analyze some data on fruit production (the mass of fruit in grams) from a mid-sire farm in South
Suppose that you have been asked to analyze some data on fruit production (the mass of fruit in grams) from a mid-sire farm in South Carolina. This problem reminds you of your favorite Agribusiness course as a student and you immediately say that you will use a regression analysis. Using Excel you have the following output SUMMARY OUTPUT Regression Statistics Multiple R 0.797851156 R Square 0.636247386 Adjusted R Square 0.48035338 Standard Error 0.361446932 Observations 11 ANOVA Significance or ss MS F Regression 3 1.599583719 0533195 4 081282 0.057175 Residual 7 0.91450719 0.130844 Total 10 2514090909 Coefficients Standard Error Star Upper P-value Lower 95% 95% Intercept 39 0.468442063 3279533 0.013498 0.428582 2.64391 Water 0.00542945 0.000963025 0.667629 0525782 -0.00163 0.0029: Light Received 0.000254354 0.000880015 0297055 0.775046 -0.00184 0.00234 Fertiliter 0.00210733 0.000848684 2 483057 0.042022 0.000101 0.00411 #1. What is the dependent variable for this problem? tpoint #2. What is the regression equation? 2 points) #3. Assume a significant level of 196. Which explanatory variables are statistically significant and why? (2 points) #4. Interpret the coefficient on the fertilizer (2 points) Suppose that you have been asked to analyze some data on fruit production (the mass of fruit in grams) from a mid-sire farm in South Carolina. This problem reminds you of your favorite Agribusiness course as a student and you immediately say that you will use a regression analysis. Using Excel you have the following output SUMMARY OUTPUT Regression Statistics Multiple R 0.797851156 R Square 0.636247386 Adjusted R Square 0.48035338 Standard Error 0.361446932 Observations 11 ANOVA Significance or ss MS F Regression 3 1.599583719 0533195 4 081282 0.057175 Residual 7 0.91450719 0.130844 Total 10 2514090909 Coefficients Standard Error Star Upper P-value Lower 95% 95% Intercept 39 0.468442063 3279533 0.013498 0.428582 2.64391 Water 0.00542945 0.000963025 0.667629 0525782 -0.00163 0.0029: Light Received 0.000254354 0.000880015 0297055 0.775046 -0.00184 0.00234 Fertiliter 0.00210733 0.000848684 2 483057 0.042022 0.000101 0.00411 #1. What is the dependent variable for this problem? tpoint #2. What is the regression equation? 2 points) #3. Assume a significant level of 196. Which explanatory variables are statistically significant and why? (2 points) #4. Interpret the coefficient on the fertilizer (2 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
