Microsoft Office Tutorials and References

In Depth Information

You are now ready to perform an ANOVA test on these data using the

following steps:

Data (at top of screen)

Data Analysis (far right at top of screen)

Anova: Single Factor (scroll up to this formula and highlight it; see Fig.
8.2
)

Fig. 8.2

Dialog Box for Data Analysis: ANOVA Single Factor

OK

Input range: A5: C17 (note that you have included in this range the column titles

that are in row 5)

Important note:

Whenever the data set has a different sample size in the groups

being compared, the INPUT RANGE that you deﬁne must start

at the column title of the ﬁrst group on the left and go to the last

column on the right to the lowest row that has a ﬁgure in it in

the entire data matrix so that the INPUT RANGE has the

‘‘ shape’’ of a rectangle when you highlight it. Since

SUBSPECIES C has 18 in cell C17, your ‘‘ rectangle’’ must include row

17!

Grouped by: Columns

Put a check mark in: Labels in First Row

Output range (click on the button to its left): A20 (see Fig.
8.3
)

Search JabSto ::

Custom Search