Create the ANOVA table using Excel or Minitab.

    

Consider the following data. X = Weekly Advertising expenditures and Y = Weekly Sales.	(worth 24 points total)
Y	X
1260	42
1390	55
1435	63
1435	55
1460	49
1310	47
1410	63
1520	62
1585	65
1660	72

 

a)         Create the ANOVA table using Excel or Minitab.                

b)         What is the prediction equation?                    ?         

c)         What is your prediction of sales if you spend $50 on advertising?                ?         

d)         Does the amount of advertising expenditures have any relationship to sales?                                              

If you need assistance with writing your assignment, essay, our professional assignments / essay writing service is here to help!

Order Now