Part IV: Regression Analysis 1. \"Demetra\" is a herbicide manufacturing company

Question

Part IV: Regression Analysis 1. "Demetra" is a herbicide manufacturing company, based in Athens, Greece. A year ago "Demetra" branded a new herbicide call "Super-H" in 30 regional markets following the success of a pre-test. You are the chief economist of "Demetra". The president of the company wants you to indicate how the demand for the new product is affected by a number of factors. Using the data set on the excel file answer the following questions: a. What is the regression equation? (Also provide the excel output) -10 points

Explanation / Answer

Regression equation-

Demand in cases=  1398.151 - 5.1518 Price per case+3.450833 Competitor Price+0.266443 Advertising+ 0.000139 household

SUMMARY OUTPUT Regression Statistics Multiple R 0.819133 R Square 0.670979 Adjusted R Square 0.618336 Standard Error 64.74587 Observations 30 ANOVA df SS MS F Significance F Regression 4 213722.1 53430.53 12.74575 8.67E-06 Residual 25 104800.7 4192.028 Total 29 318522.8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 1398.151 216.7901 6.44933 9.4E-07 951.6636 1844.639 951.6636 1844.639 price per case -5.1518 0.85531 -6.02331 2.72E-06 -6.91335 -3.39026 -6.91335 -3.39026 competitor price 3.450833 1.921955 1.795481 0.084676 -0.50751 7.409174 -0.50751 7.409174 Advertising 0.266443 0.19839 1.343024 0.191331 -0.14215 0.675035 -0.14215 0.675035 household 0.000139 0.000143 0.967651 0.342488 -0.00016 0.000434 -0.00016 0.000434

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---