Q. This is the data on advertising spends, brand_awarenss% and sales for different restaurant chains in year 2005. Using regression analysis in MS EXCEL as discussed in class answer the following.
In each case support your answer with a regression output table (one output for each part in a separate labeled tab on excel) interpreting the p-value and coefficient value if applicable. Label the tabs 4a, 4b, 4c and 4d one for each part. Explain your anwers in each tab.
a.Does advertising spend influence sales by itself? If no, why? If yes, how much do sales change for every million dollar increase in advertising expense? Why?
b.Does brand awareness affect sales by itself? If no, why? If yes, how much do sales change for every percent increasein brand_awareness? Why?
c.Does advertising affect sales controlling for brand awareness? If no, why? If yes, how much do sales change for every million dollar increase in advertising expense? Why?
d. Does brand awareness affect sales controlling for advertising? If no, why? If yes, how much do sales change for every percent increase in brand_awareness? Why?
|
Chain
|
Advertising Spend (Million Dollars)
|
Brand_awareness
|
Sales (Billion Dollars)
|
|
|
Starbucks
|
16,6
|
75
|
5,627
|
|
|
Dunkin' Donuts
|
94,4
|
39
|
3,972
|
|
|
Applebee's
|
165,6
|
43
|
4,303
|
|
|
Pizza Hut
|
213
|
64
|
5,296
|
|
|
Taco Bell
|
231,7
|
68
|
6,289
|
|
|
KFC
|
246
|
60
|
5,296
|
|
|
Burger King
|
268,8
|
82
|
7,944
|
|
|
Subway
|
325,2
|
74
|
7,282
|
|
|
Wendy's
|
374,7
|
83
|
7,613
|
|
|
McDonalds
|
727,7
|
92
|
25,487
|
|