Refer to the table. The unit sales of two brands (denoted by 1 and 2) have been summed up across several stores, whereas marketing activity variables are weighted averages across those stores. The data set contains the following variables: Week = Week number (1 to 75) Unitsj = Total units of brand j sold (j=1 to 2) across stores Pricej = Shelf price of brand j (weighted average across stores) Featj = Newspaper feature, (1 = brand "j" is featured, 0 = otherwise) Dispj = Weighted average of in In-store display, (1 = there is an in-store display for brand "j" in a store, 0 = otherwise) Using the data, calculate the own price elasticity of two brands. Explain in detail the model that you used and the steps that you follow. Please copy and paste Excel output, if any. What are the managerial implications that one can infer from your results?

chasticity_brand (1) WEEK UNTS1 PRICE 1 FEAT1 4.1 4.La 413 4.15 55 4.13 413 S Bam 3554 1 14 1 1 112 3.6 AIF 3.4445 3.5531 3.5 3.4155 13 4 SET=HE888mm - 82%8%$8% 8 88 3.543 31 4.11 41 4.15 4.13 413 32 4.1156 413 3.574 3505 3.8 3.244 DISP1 UNITS2 PRICE2 FEAT2 DISP2 a a 354 a 0 0 0 341 a 0 0 3 0 a a 1 4.1 0 a 4.17 0 0 a 1 413 a 1 0 4.13 0 1 4.13 U 413 0 0 054 1473 2 1 0 a 1774 22 a 0 0 0 0 F23 0 0 40% U 0 0 15 0 a 0 4.7 15 0 4.13 0 0 0550 4.13 0 0 6 4.13 0 a 0 4.13 a 0 0 0 4.13 a 0 0 3 0 0 31 U a 0 12 26 1 1. 0 24 0.1 0 0 0.3 0 0 23 0.43 0 1 2 0 0 0 0 1 21 a 0 0 0 24 a 200 2 1 0 0 26 0 0 1 se 0 a 3 0 0 0 1113 211 1 01 0 U 6 22 0 0 U 200 34 a 075 0 0 1 3 0 0.63 0 0 3 a 25645 1 0.1 0 0 22 0 016 0 U 0 0 0 0 112 3 0 0 53 2 1 0 0 a 0 0 1 TF 0 0 0 1 31411 0 0 1 37% 0 0 a 0 241 1 1. 1 4 259 0 0 4 0 a735 1 1 0 1 1 151 1 159 1G 1 Em88 SH 14 4 3.7 417 3. 4.5 4116 4.143 416 4.174 4.1: 4.1 4.13 SE 321 11 3.15 47 4776 1 1147 Page 1 chcocity_rnd (1) U 0 5 4 211 28 22 30 345 3 31 U a 0 1 05 1 QUES 5 1852 a a a 0 0 a a a H%%%8mmg&&&&mn 3.1774 3.4 3. 313 350 , 3.13 3.5 3.34% 3.13 3.5173 3.5413 3.564- 3.4752 3.4756 5 3.525 3.535 3 3. 19 1 45 1 1 1 10 1 1 anno1uuuuuuuuuuuuuuuuuun a a 0 mm%nmuBBS #88% 3F 30 3 345 351 3 0 a a 0 a a a 0 a a a a a a 0 a 0 a 0 a 4 313 13 1 13 13 313 313 313 313 a a 51 il nnnnn Page 2 chasticity_brand (1) WEEK UNTS1 PRICE 1 FEAT1 4.1 4.La 413 4.15 55 4.13 413 S Bam 3554 1 14 1 1 112 3.6 AIF 3.4445 3.5531 3.5 3.4155 13 4 SET=HE888mm - 82%8%$8% 8 88 3.543 31 4.11 41 4.15 4.13 413 32 4.1156 413 3.574 3505 3.8 3.244 DISP1 UNITS2 PRICE2 FEAT2 DISP2 a a 354 a 0 0 0 341 a 0 0 3 0 a a 1 4.1 0 a 4.17 0 0 a 1 413 a 1 0 4.13 0 1 4.13 U 413 0 0 054 1473 2 1 0 a 1774 22 a 0 0 0 0 F23 0 0 40% U 0 0 15 0 a 0 4.7 15 0 4.13 0 0 0550 4.13 0 0 6 4.13 0 a 0 4.13 a 0 0 0 4.13 a 0 0 3 0 0 31 U a 0 12 26 1 1. 0 24 0.1 0 0 0.3 0 0 23 0.43 0 1 2 0 0 0 0 1 21 a 0 0 0 24 a 200 2 1 0 0 26 0 0 1 se 0 a 3 0 0 0 1113 211 1 01 0 U 6 22 0 0 U 200 34 a 075 0 0 1 3 0 0.63 0 0 3 a 25645 1 0.1 0 0 22 0 016 0 U 0 0 0 0 112 3 0 0 53 2 1 0 0 a 0 0 1 TF 0 0 0 1 31411 0 0 1 37% 0 0 a 0 241 1 1. 1 4 259 0 0 4 0 a735 1 1 0 1 1 151 1 159 1G 1 Em88 SH 14 4 3.7 417 3. 4.5 4116 4.143 416 4.174 4.1: 4.1 4.13 SE 321 11 3.15 47 4776 1 1147 Page 1 chcocity_rnd (1) U 0 5 4 211 28 22 30 345 3 31 U a 0 1 05 1 QUES 5 1852 a a a 0 0 a a a H%%%8mmg&&&&mn 3.1774 3.4 3. 313 350 , 3.13 3.5 3.34% 3.13 3.5173 3.5413 3.564- 3.4752 3.4756 5 3.525 3.535 3 3. 19 1 45 1 1 1 10 1 1 anno1uuuuuuuuuuuuuuuuuun a a 0 mm%nmuBBS #88% 3F 30 3 345 351 3 0 a a 0 a a a 0 a a a a a a 0 a 0 a 0 a 4 313 13 1 13 13 313 313 313 313 a a 51 il nnnnn Page 2