Microsoft Office Tutorials and References

In Depth Information

Chapter 8

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:

A3:

SOUND BURSTS OF DANCING FORAGER HONEY BEES

A5:

SUBSPECIES A

B5:

SUBSPECIES B

C5:

SUBSPECIES C

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

159

Search JabSto ::

Custom Search