Question

How do I complete this in Excel . Calculation  ANOVA

Using one-way analysis of variance on the data assuming the populations have equal variances and the populations are normally distributed. Use alpha = 0.05.

three samples obtained independently from 3 population

Item	Group A	Group B	Group C
1	14	17	17
2	13	16	14
3	12	16	15
4	15	18	16
5	16		14
6			16

Answer 1

We can perform ANOVA using excel .

Go to Data menu ---> data analysis ----> Select Anova: Single Factor

For Input range select the entire data table ( with headings ).

Check the box for "Labels in first Row" . ( If you did not select the column heading then do not need to check this box )

Then click on OK.

: µ₁ = µ₂ = µ₃

: At least one group mean is different.

Given : α = 0.05 and we have P value = 0.0259

As P value is less than 0.05, we reject the null hypothesis H0

Conclusion : There is significant evidence that at least one group mean is different.