Part 2: Understanding the Drivers of Price Competition

Attached data file "HW2 Pizza data.xls" shows the prices and quantities sold for six major brands of frozen pizza for 156 weeks in a major Midwestern market.

link to xls file: https://drive.google.com/file/d/1nyQ80ASLwiRDPNAlHVo_4x_kMH75M6Yi/view?usp=sharing

1.Calculate Clout, Vulnerability and Dominance ratio for each brands using an elasticity matrix.

Note: For this question, in any regression, an estimate that has a p-value of less than or equal to 0.1 should be considered statistically significant. An elasticity number with p>0.1 should be considered as zero.

2. MAKE an graph with x-axis as "clout" and "y-axis" as vulnerability and locate each brand on this map as a circle whose size represents the average market share (in units) during these 156 weeks.