Exercise 25.4: A consumer preference study involving three different bottle designs for a new laundry product was carried out in four supermarkets. The data below analyze the results of the number of sales in a 24-hour period Anova: Two-Factor Without Replication SUMMARY Count Sum Average Variance Bottle A 4 37 9.25 48.91667 Bottle B 105 26.25 40.91667 Bottle C 4 84 21 98 Mkt 1 3 72 24 73 Mkt 2 3 65 21.66667 64.33333 Mkt 3 3 28 9.333333 82.33333 Mkt 4 W 61 20.33333 174.3333 ANOVA Test Statistic Source of Variation SS df MS F P-value F crit Rows (Bottle) 606.1667 2 303.0833 10.00092 0.012287 5.143253 Columns (MKT) 381.6667 3 127.2222 4.197984 0.063938 4.757063 Error 181.8333 6 30.30556 Total 1169.667 11 a. What is the variance that is explained by bottle identity? b. What is the variance that is explained by supermarket identity? c. What is the unexplained variance? d. At the 5% significance level, are there any differences in sales by bottle design? I Hypotheses: Ho: HA: II. Decision Rule: a= n of = d df = Draw and label the rejection region(s) below. State the decision rule below. III. Test Statistic F: IV. Conclusion (Reject Ho vs Do not Reject Ho): Conclusion (use complete sentence):e. At the 5% significance level, are there any differences in sales by supermarket identity? I Hypotheses: Ho: HA: II. Decision Rule: a = n df = d df = Draw and label the rejection region(s) below. State the decision rule below. III. Test Statistic F: IV. Conclusion (Reject Ho vs Do not Reject Ho): Conclusion (use complete sentence)