Question
This problem requires the use of the filemayo.xls. It contains information on the sales of Kraft mayonnaise from Chicago area Jewel stores. The data is
This problem requires the use of the filemayo.xls. It contains information on the sales of Kraft mayonnaise from Chicago area Jewel stores. The data is divided into two parts. The first part includes data Kraft sales, including total demand (SALES U) and total revenue (SALES $). This is translated into unit price information. Log data is also provided. The data runs weekly from 1991 through 1992, with some weeks missing.
The second set of data contains price information of the competitors, Hellman's and Miracle Whip. The prices in this data set are retail prices that Jewel grocery store offered to its buyers.
- Develop a regression model to estimate the demand of Kraft's mayon- naise as a function of Kraft's price only. (Consider the three forms of regression model discussed in class.)Explainandjustifyyour choice of which of the three regression models to use. What is the estimate of the elasticity of demand for Kraft mayonnaise from your chosen model?
- Repeat the above, but include the prices of the other two products. Now what is the estimate of the elasticity of demand for Kraft may- onnaise?
- If one were to obtain different estimates of elasticity from these two models, which one should be used and why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started