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

ABC172923183024173322143323173121

The Excel output of a one-way ANOVA of the Bottle Design Study Data is shown below.

SUMMARY

GroupsCountSumAverageVarianceDesign A58316.62.3Design B515631.23.2Design C511322.61.3

ANOVA

SOURCE OF VARIATIONSSDFMSFP=-VALUEFcritBetween Groups538.53332269.2667118.791.24E-083.88529Within Groups27.2122.267Total565.733314

a.Test the null hypothesis that uA, uB, and uC are equal by setting a = .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 = __________

p-value = _____________

__________ H0: bottle design ______________ have an impact on sales.

b. Consider the pairwise differences uB - uA, uC - uA, and uC - uB.Find a point estimate of and a Turkey simultaneous 95 percent confidence interval for each pairwise difference. Interpret the results in practical terms.Which bottle design maximizes mean daily sales? (Round your answers to 2 decimal places.Negative amounts should be indicated by a a minus sign.)

Point estimate Confidence interval

uB - uA:___________ , [____________ , ______________]

uC - uA: ____________ , [____________ , ______________]

uC - uB: ____________ , [____________ , ______________]

Bottle design _________ maximizes sales.

c. Find a 95 percent confidence interval for each of the treatment means uA, uB, and uC. Interpret these intervals.Round your answers to 2 decimal places.Negative amounts should be indicated by a minus sign.

Confidence interval

uA:[ ___________ , ______________]

uB:[ ___________ , ______________]

uC:[ ___________ , ______________]