Question

A researcher was interested in the difference in preference in a required brew across three different bars in their town. The researcher was able to gather the preferences for five people from each of the bars. The data collected is below.

Cooler	Coors	Keystone
71	68	82
69	48	91
86	56	88
88	50	95
52	83	72

Conduct the test to let the researcher know whether the brews are statistically significantly different across the bars.

Your answer must include:

a. Your hypotheses

b. Your test statistic

c. Your p-value

d. Your conclusion

Answer 1

In order to solve this question I used Excel.

Step.1 Enter data in excel sheet.

Step.2 Go to 'Data' menu ---> 'Data Analysis' ---> Select 'ANOVA : Single Factor'.

Step.3 New window pop-up on screen. Refer following screen shot and enter information accordingly.

Excel output:

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
cooler	5	366	73.2	213.7
coors	5	305	61	212
keystone	5	428	85.6	80.3
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	1512.933	2	756.4667	4.48498	0.035116	3.885294
Within Groups	2024	12	168.6667
Total	3536.933	14

a.

Hypothesis:

Ha : At least one mean is significantly different than other.

b.

Test statistic, F = 4.48498

c.

p-value = 0.035116

d.

Since p-value is less than 0.05, we reject null hypothesis and conclude that brews are statistically significantly different across the bars.