Question
This table below (bottom)contains 113 weeks of sales information for the following variables from the frankfurter category: BrandA_Share: BrandA market share (as a proportion) BrandA_Price:
This table below (bottom)contains 113 weeks of sales information for the following variables from the frankfurter category:
BrandA_Share: BrandA market share (as a proportion)
BrandA_Price: price of BrandA hotdogs in dollars
BrandB_Price: price of BrandB hotdogs in dollars
BrandC_Price: price of BrandC hotdogs in dollars
BrandD_Price: price of BrandD hotdogs in dollars
Next, run a regression with market share as the dependent variable and BrandA_Price, BrandB_Price and BrandC_Price as the independent variables. That is, estimate the model,
BrandA_Share = b0 + b1BrandA_Price + b2BrandB_Price + b3BrandC_Price
Copy and paste the regression results.
(a) Write down and interpret the coefficient on BrandA_Price.
(b) Write down and interpret the coefficient on BrandC_Price.
(c) Does our estimate of the intercept (the b0 coefficient) have any managerial interpretation? If yes, please provide the interpretation. If No, then please briefly explain why.
(d) If BrandB and BrandC hotdogs are both priced at $1.60, what is the predicted market share for BrandA hotdogs if it prices itself at $1.50?
(e) If we think of the "closest" competitor as that whose price changes affect market share the greatest, can the regression output be used to figure out which of the competing brands (BrandB or BrandC) is the closest competitor to BrandA hotdogs? If not, why not? If yes, which brand is the closest competitor?
BrandA_Price | BrandA_Share | BrandD_Price | BrandC_Price | BrandB_Price |
1.49 | 0.0455 | 1.79 | 1.69 | 1.69 |
1.49 | 0.093 | 1.99 | 1.89 | 1.99 |
1.89 | 0.0597 | 1.99 | 1.89 | 1.99 |
1.89 | 0.0346 | 1.99 | 1.89 | 1.99 |
1.89 | 0.0277 | 1.69 | 1.59 | 1.69 |
1.89 | 0.0294 | 1.99 | 1.89 | 1.99 |
1.89 | 0.0369 | 1.99 | 1.89 | 1.99 |
1.89 | 0.0413 | 1.99 | 1.89 | 1.89 |
1.89 | 0.0291 | 1.79 | 1.69 | 1.89 |
1.89 | 0.0392 | 1.99 | 1.89 | 1.89 |
1.89 | 0.0336 | 1.99 | 1.89 | 1.89 |
1.89 | 0.0345 | 1.99 | 1.89 | 1.79 |
1.89 | 0.0415 | 1.99 | 1.89 | 1.89 |
1.89 | 0.0355 | 1.99 | 1.89 | 1.89 |
1.89 | 0.0373 | 1.99 | 1.89 | 1.79 |
1.89 | 0.0388 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0346 | 1.89 | 1.79 | 1.89 |
1.79 | 0.0309 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0306 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0358 | 1.99 | 1.89 | 1.59 |
1.79 | 0.0341 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0292 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0303 | 1.99 | 1.89 | 1.89 |
1.79 | 0.0343 | 1.99 | 1.89 | 1.89 |
1.48 | 0.0604 | 1.88 | 1.78 | 1.68 |
1.48 | 0.0356 | 1.88 | 1.78 | 1.68 |
1.48 | 0.0385 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0486 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0398 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0498 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0577 | 1.88 | 1.78 | 1.68 |
1.48 | 0.0314 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0489 | 1.69 | 1.59 | 1.68 |
1.48 | 0.0475 | 1.88 | 1.78 | 1.68 |
1.48 | 0.0367 | 1.59 | 1.49 | 1.68 |
1.48 | 0.0411 | 1.59 | 1.49 | 1.68 |
1.48 | 0.0488 | 1.88 | 1.78 | 1.68 |
1.48 | 0.0313 | 1.59 | 1.49 | 1.68 |
1.69 | 0.0225 | 1.59 | 1.49 | 1.59 |
1.69 | 0.0307 | 1.59 | 1.49 | 1.59 |
1.69 | 0.0292 | 1.49 | 1.49 | 1.79 |
1.59 | 0.0213 | 1.49 | 1.49 | 1.59 |
1.59 | 0.0286 | 1.49 | 1.49 | 1.59 |
1.69 | 0.0252 | 1.89 | 1.79 | 1.79 |
1.59 | 0.0873 | 1.89 | 1.79 | 1.79 |
1.59 | 0.0544 | 1.89 | 1.79 | 1.59 |
1.59 | 0.023 | 1.59 | 1.49 | 1.49 |
1.59 | 0.0287 | 1.59 | 1.49 | 1.49 |
1.69 | 0.0304 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0271 | 1.69 | 1.59 | 1.69 |
1.69 | 0.0195 | 1.69 | 1.59 | 1.69 |
1.49 | 0.0465 | 1.69 | 1.59 | 1.79 |
1.49 | 0.0343 | 1.69 | 1.59 | 1.49 |
1.69 | 0.0236 | 1.69 | 1.59 | 1.49 |
1.69 | 0.0223 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0171 | 1.69 | 1.59 | 1.49 |
1.59 | 0.0408 | 1.69 | 1.59 | 1.49 |
1.59 | 0.0328 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0317 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0225 | 1.59 | 1.49 | 1.79 |
1.69 | 0.0224 | 1.59 | 1.49 | 1.59 |
1.69 | 0.0291 | 1.89 | 1.79 | 1.59 |
1.69 | 0.0309 | 1.89 | 1.79 | 1.59 |
1.39 | 0.0603 | 1.89 | 1.79 | 1.59 |
1.39 | 0.04 | 1.89 | 1.79 | 1.59 |
1.69 | 0.0242 | 1.69 | 1.59 | 1.59 |
1.69 | 0.0257 | 1.69 | 1.59 | 1.59 |
1.69 | 0.0313 | 1.89 | 1.79 | 1.59 |
1.59 | 0.04 | 1.69 | 1.59 | 1.79 |
1.59 | 0.0265 | 1.69 | 1.59 | 1.79 |
1.50 | 0.0655 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0244 | 1.89 | 1.79 | 1.59 |
1.69 | 0.0173 | 1.69 | 1.59 | 1.59 |
1.78 | 0.0187 | 1.69 | 1.59 | 1.79 |
1.78 | 0.0229 | 1.89 | 1.79 | 1.69 |
1.69 | 0.036 | 1.79 | 1.69 | 1.69 |
1.69 | 0.0245 | 1.79 | 1.69 | 1.79 |
1.69 | 0.0344 | 1.89 | 1.79 | 1.69 |
1.69 | 0.0242 | 1.69 | 1.59 | 1.69 |
1.78 | 0.0169 | 1.69 | 1.59 | 1.79 |
1.69 | 0.0348 | 1.69 | 1.59 | 1.69 |
1.69 | 0.0259 | 1.89 | 1.79 | 1.69 |
1.78 | 0.0288 | 1.89 | 1.79 | 1.69 |
1.78 | 0.0193 | 1.69 | 1.59 | 1.69 |
1.78 | 0.0171 | 1.69 | 1.59 | 1.79 |
1.59 | 0.0485 | 1.89 | 1.79 | 1.79 |
1.59 | 0.0233 | 1.89 | 1.79 | 1.49 |
1.78 | 0.0146 | 1.49 | 1.49 | 1.49 |
1.59 | 0.0502 | 1.49 | 1.49 | 1.49 |
1.59 | 0.053 | 1.89 | 1.79 | 1.79 |
1.78 | 0.0249 | 1.89 | 1.79 | 1.69 |
1.78 | 0.0139 | 1.49 | 1.49 | 1.69 |
1.49 | 0.0258 | 1.49 | 1.49 | 1.29 |
1.49 | 0.0319 | 1.49 | 1.49 | 1.29 |
1.78 | 0.0224 | 1.49 | 1.49 | 1.79 |
1.78 | 0.0217 | 1.49 | 1.49 | 1.49 |
1.59 | 0.0562 | 1.89 | 1.79 | 1.49 |
1.59 | 0.0304 | 1.69 | 1.59 | 1.59 |
1.78 | 0.0165 | 1.69 | 1.59 | 1.59 |
1.59 | 0.0457 | 1.89 | 1.79 | 1.79 |
1.59 | 0.0355 | 1.89 | 1.79 | 1.49 |
1.59 | 0.0236 | 1.49 | 1.39 | 1.49 |
1.59 | 0.0494 | 1.49 | 1.39 | 1.49 |
1.59 | 0.0324 | 1.69 | 1.69 | 1.79 |
1.79 | 0.0224 | 1.69 | 1.69 | 1.79 |
1.79 | 0.0191 | 1.59 | 1.59 | 1.79 |
1.59 | 0.035 | 1.59 | 1.59 | 1.79 |
1.59 | 0.0296 | 1.69 | 1.69 | 1.79 |
1.79 | 0.0235 | 1.69 | 1.69 | 1.79 |
1.79 | 0.0252 | 1.89 | 1.79 | 1.79 |
1.59 | 0.0544 | 1.89 | 1.79 | 1.69 |
1.59 | 0.0618 | 1.89 | 1.79 | 1.69 |
1.49 | 0.0748 | 1.89 | 1.79 | 1.69 |
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