A consumer preference study compares the effects of three different bottle designs (A, B, and C) on sales of a popular fabric softener. A completely randomized design is employed. Specifically, 15 supermarkets of equal sales potential are selected, and 5 of these supermarkets are randomly assigned to each bottle design. The number of bottles sold in 24 hours at each supermarket is recorded. The data obtained are displayed in the following table.

Bottle Design Study Data

A B C

14 31 24

17 32 25

13 29 28

14 30 27

15 34 28

Conduct the appropriate ANOVA test in excel and obtain the ANOVA table output to answer the following questions.

Test the null hypothesis that _A, _B, and _C are equal by setting = .05. Based on this test, can we conclude that bottle designs A, B, and C have different effects on mean daily sales? (Round your answers to 2 decimal places.)

F =