Microsoft Office Tutorials and References
In Depth Information
One-Way Analysis Of Variance (ANOVA)
So far in this 2007 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.
Important note: In order to do One-way Analysis of Variance, you need to have
installed the “Data Analysis Toolpak” that was described in Chapter 6 (see Sect.
6.5.1). If you did not install this, you need to do that now.
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 meters 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 Figure 8.1 . Is there any evidence that these three
subspecies of honey bees produce a different number of sound bursts per cycle?
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!)
Create an Excel spreadsheet for these data in this way:
SOUND BURSTS OF DANCING FORAGER HONEY BEES
T.J. Quirk et al., Excel 2007 for Biological and Life Sciences Statistics ,
DOI 10.1007/978-1-4614-6003-9_8, # Springer Science+Business Media New York 2013
Search JabSto ::