Question


2. Using the following regression summery output for the estimation of demand for a product. 9691 Regression Statistics R Squ
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a. The F-statistic for the regression model is 318.144172.
The F-critical value at F.001,3,31 is approximately 7. Since 318 > 7, we reject the null hypothesis of no overall significance of the model. It means, the regression model is significant as a whole.

b. The p-value of Price (Px) is very low (i.e. 0.000), therefore it is signficant.
The p-value of Other Price (Py) is 0.015, which means it is significant but only till 98.5% (=100-1.5). It is not significant at, say 99%.
The p-value of Income (I), again, is very low. Therefore, it is significant.

c. The R-squared of the model is 0.969 or 96.9%. It means that the independent variables explain 96.9% variation in the average value o the dependent variable, while the rest 3.1% is not explained by the model and is the error term component.
Therefore, the everage demand for a product is 96.9% affected by its price, other price, and income level. The rest is affected by some other factors not included in the model.

d. Qx = 87.30 - 0.80Px - 0.60Py + I

Add a comment
Know the answer?
Add Answer to:
2. Using the following regression summery output for the estimation of demand for a product. 9691...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Calculate the following statistics given the existing information (1 point per calculation): Regression Statistics Multiple R...

    Calculate the following statistics given the existing information (1 point per calculation): Regression Statistics Multiple R R Square Adjusted R Square 0.559058 Standard Error Observations 30 ANOVA df SS MS F Significance F Regression 2 3609132796 19.38411515 6.02827E-06 Residual 27 2513568062 Total 29 6122700857 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -15800.8 57294.51554 -0.27578 0.784814722 CARAT 12266.83 1999.250369 6.135715 1.48071E-06 DEPTH 156.686 928.9461882 0.168671 0.867312915 Additionally interpret your results. Be sure to comment on Accuracy, significance...

  • You estimate the demand function for soft drinks using a multiple regression model. The MS Excel...

    You estimate the demand function for soft drinks using a multiple regression model. The MS Excel printout for the regression follows: SUMMARY OUTPUT Regression Statistics Multiple R 0.835478305 R Square 0.698023997 Adjusted R Square 0.677434724 Standard Error 38.26108281 Observations 48 ANOVA df SS MS F Significance F Regression 3 148889.8565 49629.95217 33.9023141 1.64557E-11 Residual 44 64412.06016 1463.910458 Total 47 213301.9167 Coefficients Standard Error t Stat P-value Intercept 514.2669369 113.3315243 4.537721874 4.36383E-05 6 pack price 242.9707509 43.52628127 5.582161944 1.38245E-06 mean temp...

  • 7,10,11 Based on the following regression output, what is the equation of the regression line? Regression...

    7,10,11 Based on the following regression output, what is the equation of the regression line? Regression Statistics Multiple R 0.917214 R Square 0.841282 Adjusted R Square 0.821442 Standard Error 9.385572 Observations 10 ANOVA df SS MS Significance F 1 Regression 3735.3060 3735.30600 42.40379 0.000186 8 Residual 704.7117 88.08896 9 Total 4440.0170 Coefficients Standard Error t Stat P-value Lower 95% Intercept 31.623780 10.442970 3.028236 0.016353 7.542233 X Variable 1.131661 0.173786 6.511819 0.000186 0.730910 o a. 9; = 7.542233+0.7309 Xli o b....

  • SUMMARY OUTPUT Regression Statistics Multiple R 0.818616296 R Squa...

    SUMMARY OUTPUT Regression Statistics Multiple R 0.818616296 R Square 0.67013264 Adjusted R Square 0.658351663 Standard Error 9.16867179 Observations 30 ANOVA df SS MS F Significance F Regression 1 4781.80995 4781.80995 56.8826 3.2455E-08 Residual 28 2353.807187 84.06454239 Total 29 7135.617137 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 28.21496731 3.739591617 7.544932763 3.22E-08 20.55476114 35.87517349 Dividend 2.367177613 0.313863719 7.542055589 3.25E-08 1.724256931 3.010098296 c. You run a regression analysis using Data Analysis to answer the following question: Is stock selling...

  • Figure 2 Regression Output SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard...

    Figure 2 Regression Output SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.921261 0.848722 0.8055 0.711125 10 ANOVA Significance MS 0.001347 Regression Residual Total 19.86011 9.930053 19.63628 3.539894 0.505699 23.4 Standard Error Upper 95% Coefficients 0.20018 2.211198 0.07185 tStat P-value Lower 95% Intercept Size (cubic Metres) Weight (00's kg 2.19481 1.794453 0.676122 3.270412 0.013667 0.612423 3.809974 0.47295 0.329255 0.84353 -0.23731 0.819212 0.169626 0.42356 0.684594 (a)Based on the above regression output, interpret the regression coefficients...

  • QUESTION 20 From the Regression output below, what is the impact on the quantity demand of...

    QUESTION 20 From the Regression output below, what is the impact on the quantity demand of water when incomes increase by 3% Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.925 0.856 0.846 0.059 45 ANOVA 81.46 Regression Residual Total SMS 0.85 0.28 0.14 0.00 0.99 t Intercept PRICE INCOME WEATHER Coefficients 13.040 -0.200 1.500 0.124 Standard Error 0.758 0.063 0.079 0.065 Stat 17.194 -7.904 13.162 1.909 P-value 0.000 0.000 0.000 0.063 A. Increase by 3%...

  • IN THE BELOW REGRESSION MODEL, FULLY INTERPRET THE REGRESSION (SLOPE) COEFFICIENTS AND COMMENT ON THEIR STATISTICAL...

    IN THE BELOW REGRESSION MODEL, FULLY INTERPRET THE REGRESSION (SLOPE) COEFFICIENTS AND COMMENT ON THEIR STATISTICAL SIGNIFICANCE. IN DISCUSSING STATISTICAL SIGNIFICANCE OF A REGRESSION COEFFICIENT, YOU HAVE TO JUSTIFY YOUR CHOICE OF A ONE OR TWO TAIL TEST. SUMMARY OUTPUT Regression Statistics Multiple R 0.48457333 R Square 0.23481131 Adjusted R Square 0.21365402 Standard Error 1.18083028 Observations 224 ANOVA df SS MS F Significance F Regression 6 92.8506974 15.4751162 11.0983638 8.6676E-11 Residual 217 302.576153 1.39436015 Total 223 395.42685 Coefficients Standard Error...

  • 1st regression analysis 2nd regression analysis 1. Analyze the two regression analysis's above ...

    1st regression analysis 2nd regression analysis 1. Analyze the two regression analysis's above and make a recommendation on if the organization should increase, decrease, or retain their pricing and why? 2. What happens to the dependent variable Y if the price X1 decreases in the second regression analysis? SUMMARY OUTPUT Y=UNITS SOLD X=PRICE Regression Statistics Multiple R R Square Adiusted R S Standard Error Observations 0.874493978 0.764739718 0.756026374 159.2178137 29 quare ANOVA df MS Significance F 1 2224908.261 2224908.26187.76650338 5.64792E-10...

  • 12. (9 Points) Using the Regression Computer Output to the right, find/calculate: SUMMARY OUTPUT Regression Statistics...

    12. (9 Points) Using the Regression Computer Output to the right, find/calculate: SUMMARY OUTPUT Regression Statistics Multiple R 0.928717 R Square 0.862516 Adjusted R Square 0.835019 Standard Error 1.987885 Observations (A) The value of the Slope, b. ANOVA df 31.36785 a. 1.103933 b. 18.16292 c. 5.6007 d. 3.951685 e. 2.004566 Regression Residual Total SS MS 123.9559 123.9559 19.758433.951685 143.7143 Intercept Coefficients 18.16292 1.103933 Standard Error 2.004566 0.197106 t Stat 9.060773 5.6007 P-value 0.000274 0.002507 (B) The value of the Correlation...

  • Regression Analysis 2 You run a regression analysis and receive the following results SUMMARY OUTPUT Regression...

    Regression Analysis 2 You run a regression analysis and receive the following results SUMMARY OUTPUT Regression Statistics Multiple R 0 .9697622171 R Square 0.940438758 Adjusted R Square 0.92058501 Standard Error 360.0073099 Observations 5 IIIIIIII ANOVAT di SS M S F Sanificance Regression 11 6 139184 2116139184 2111 47 368327870 000 Residual 3 3 88.815.78951129605,26321 Total 146528000T IUSTI Intercept X Variable 1 Coefficients 2056. 58 1.50 Standard Error 4 54.25 0.1816 Stat 6.728812231 .882465029 P-value 0006701290 0.006283174 Refer to the Regression...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT