Question

The following is sample information. Test the hypothesis that the treatment means are equal. Use the 0.05 significance level.

Treatment 1	Treatment 2	Treatment 3
3	4	8
6	3	10
3	8	6
10	7	8

Question: Complete the ANOVA table. (Round the SS, MS, and F values to 3 decimal places.)

Source	SS	DF	MS	F
Treatment
Error
Total

Please explain how you got your answers the best you can. I am trying to learn to do this myself. Thank you.

Answer 1

By using excel we can solve this question easily.

First, enter all data into excel.

Click on Data -------> Data Analysis--------> Anova: Single-Factor-----> Input Data -------> Select all data -------> Output Range : Select any empty cell --------> ok
We get

ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	16.66667	2	8.333333	1.293103	0.32089	4.256495
Within Groups	58	9	6.444444
Total	74.66667	11

We have to test the hypothesis that the treatment means are equal. Use the 0.05 significance level.

The null and alternative hypothesis is

H1: At least one of the mean is different.

Test statistic F = 1.29

Critical value = 4.26

Test statistic < critical value we fail to reject null hypothesis.

Conclusion: The treatment means are equal.