A consumer preference study compares the effects of three different bottle designs (A. E. and C.) on sales of a popular fabric softener. A completelyI randomized design is employed. Specically. 15 supermarkets of equal sales potential are selected. and 5 ofthese 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 Date I. B C 1'? 34 2]. 16 30 2]. 13 34 28 13 30 26 16 34 25 The Excel output of a one-wayI ANOVA of the Bottle Design StudyI Data is shown below. SUMMARY Group: Count: Sum Average Variance Design A 5 75 15.0 3.5 Design 5 5 162 32.-i 4.8 Design C 5 121 24.2 9.7 mm Source of Variation ES df ES F Panua F Grit Between Group! 75?.7333 2 313.566? 63.14 4.273-07 3.89529 Within Groups 72.0 12.0 6.0000 Total 329.7333 14 la) Test the hull hypothesis that #3, #9 and of, 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.) HCI: bottle design _ have an impact on sales. (b) Consider the pairwise differences up - HA, UC - HA, and up - up. Find a point estimate of and a Tukey 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 minus sign.) Point estimate Confidence interval HB -JA: UC -JA: UC -UB: Bottle design maximizes sales. (c) Find a 95 percent confidence interval for each of the treatment means A, Ag, and uc. Interpret these intervals. (Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign.) Confidence interval JA: [ HB: [