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?

Create the ANOVA table using Excel or Minitab.

NOT RATED

Purchase the answer to view it