Excel formula answer need
kenyali333
Book3.xlsxSheet1
| The marketing department of a company has designed three different boxes for its product. It wants to determine which box will produce the largest amount of sales. Each box will be test marketed in five different stores for a period of a month. Below you are given the information on sales. | Answer the questions with excel formula by using the following numbers "I need to see all formula when I click on the answers" | ||||||
| a. | State the null and alternative hypotheses. | ||||||
| b. | Construct an ANOVA table. | ||||||
| c. | What conclusion do you draw? | ||||||
| Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | |||
| Box 1 | 210 | 230 | 190 | 180 | 190 | ||
| Box 2 | 195 | 170 | 200 | 190 | 193 | ||
| Box 3 | 295 | 275 | 290 | 275 | 265 |
