Microsoft Office Tutorials and References
In Depth Information
One-Way Analysis of Variance (ANOVA)
So far in this 2010 Excel Guide, you have learned how to use a one-group t-test to
compare the sample mean to the population mean, and a two-group t-test to test for
the difference between two sample means. But what should you do when you have
more than two groups and you want to determine if there is a signiﬁcant difference
between the means of these groups?
The answer to this question is: Analysis of Variance (ANOVA).
The ANOVA test allows you to test for the difference between the means when
you have three or more groups in your research study.
In order to do One-way Analysis of Variance, you need to have
installed the ‘‘ Data Analysis Toolpak’’ that was described in
Let’s suppose that you wanted to study the sound bursts of three subspecies of
forager honey bees in relation to a food source that was 400 m from their hive.
These honey bees ‘‘dance’’ by producing sound bursts in a cycle, and the
researchers have obtained the average number of sound bursts per cycle for these
bees. The hypothetical results are given in Fig. 8.1 . Is there any evidence that these
three subspecies of honey bees produce a different number of sound bursts per
You have been asked to analyze the data to determine if there was any
signiﬁcant difference in the average number of sound bursts per cycle between the
three subspecies of honey bees. To test your Excel skills, you have selected a
random sample of bees from each of these subspecies (see Fig. 8.1 ). Note that each
subspecies can have a different number of bees in order for ANOVA to be used on
the data. Statisticians delight in this fact by referring to this characteristic by
stating that: ‘‘ANOVA is a very robust test.’’ (Statisticians love that term!)
T. J. Quirk et al., Excel 2010 for Biological and Life Sciences Statistics,
Springer Science+Business Media New York 2013
Search JabSto ::