Question

A beer distributor is comparing quarterly sales of Coors Light (number of six-packs sold) at three convenience stores. Does this sample provide sufficient evidence to conclude that there is a significant difference in treatment means?

NOTE: I am having issues with the STD.DEV column and the Store and Quarter Totals. All other parts have been completed.

A beer distributor is comparing quarterly sales of Coors Light (number of six-packs sold) at three convenience stores. Does this sample provide sufficient evidence to conclude that there is a significant difference in treatment means? Qtr 2 Qtr 3 Qtr 4 Sfore 1 1.521 1,396 1.178 1.730 Store 2 1,298 1,492 1,052 1,659 Store 3 1,708 1,382 1,132 1,851 (a) Choose the correct statement. Quarter is the treatment or research interest and store is the blocking factor. Quarter is the blocking factor and store is the treatment or research interest. (b) Fill in the missing data. (Round your p-values to 4 decimal places, SS values to 2 decimal places, and other answers to 3 decimal places.) Two-Factor ANOVA df MS 20569.333 Treatments (Store) Blocks (Qtr) 41138.67 601990.92 77277.33 1.597 15.580 0.2779 0.0031 200663.639 12879.556 720406.92 Mean Std. Dev Store 1 Store 2 Store 3 Qtr 1 Qtr 2 Qtr 3 Qtr 4 1456.250 1375.250 1518.250 1509.000 1423.333 1120.667 1746.667 53394.92 68200.92 104826.9 42133 3585.333 4065.333 9424.333 Total 35

Answer 1

Answer:

NOTE: I am having issues with the STD.DEV column and the Store and Quarter Totals. All other parts have been completed.

( you entered variance instead of standard deviation)

Total 12 observations , not 35 as you entered)

	mean	n	standard deviation
	1456.250	4	231.073
	1375.250	4	261.153
	1518.250	4	323.770
	1509.000	3	205.263
	1423.333	3	59.878
	1120.667	3	63.760
	1746.667	3	97.079
Total	1,449.917	12	255.913