Question

The table below presents three samples of data. If we conduct a hypothesis test for the equality of all three means with the statistical confidence of 90%, what would the value of the Mean Squares Between Groups be?

Sample 1	Sample 2	Sample 3
7	11	6
5	8	5
7	11	4
6	7	5
6	13	14
6	13	5
6	12	5
6	11	6
8	8	8
9	7	6
7	6	14
9	7	4
8	8	8
8	9	13
9	6	10
8	11	14
8	9	14
9	12	8
6	11
8	12
12	9
11	5

Answer 1

For the given data using Anova single factor in Excel we get output as

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Sample 1	22	169	7.681818	2.989177
Sample 2	22	206	9.363636	5.95671
Sample 3	18	149	8.277778	14.80065
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	31.88009	2	15.94005	2.13997	0.126703	2.394832
Within Groups	439.4747	59	7.448725
Total	471.3548	61

So from the above output

Mean Squares Between Groups = 15.94005