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