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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!