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 define must start
at the column title of the first group on the left and go to the last
column on the right to the lowest row that has a figure 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