Does advertising spend influence sales by itself

Assignment Help Financial Management

Reference no: EM131930141

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

Reference no: EM131930141

Questions Cloud

Develop a network representation of the problem : Formulate the problem as a linear program, with the optimal solution providing the hours each consultant should be scheduled for each client.

Store the given dictionaries in a list called pets : Store these dictionaries in a list called pets. Next, loop through your list and as you do print everything you know about each pet.

Why do standard matter in agua fabrics : How ISO 9000:2005 and 9004:2009, 19011:2011 would have helped Agua Fabric in getting ISO Certification?

Find the minimum number of periods required : Find the minimum number of periods required to add 100 floating-point numbers A1 + A2 + - + Al00 using this pipeline adder.

Does advertising spend influence sales by itself : 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?

Prepare a schematic design of five-stage multiply pipeline : Prepare a schematic design of the five-stage multiply pipeline. All line widths and inter-stage connections must be shown.

How will you build quality assurance and quality control : You are the PM for a project for a formal dinner at TSTC campaigning for money for student scholarships.

What is an economic analysis of tort law : What is an economic analysis of Tort Law? What are some of the assumption developed when analyzing the Tort Law? Give examples.

How are quality of conformance and quality of design : How are quality of conformance and quality of design related to one another? Can a product achieve quality of design but not quality of conformance?

User Account

All Pages