Microsoft Office Tutorials and References
In Depth Information
Fig. 8.2 Dialog Box for Data Analysis: Anova Single Factor
Data Analysis (far right at top of screen)
Anova: Single Factor ( scroll up to this formula and highlight it ; see Fig. 8.2 )
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 )
OK
Save this file as: BEE11
You should have generated the table given in Fig. 8.4 .
Center all of the numbers in the ANOVA table, and round off all numbers that
are decimals to two decimal places.
Save this file as: BEE12
Print out both the data table and the ANOVA summary table so that all of this
information fits onto one page. (Hint: Set the Page Layout / Fit to Scale to 85%
size ).
As a check on your analysis, you should have the following in these cells:
A20: Anova: Single Factor
D25:
14.66
B26:
12
D32:
1.67
Search JabSto ::




Custom Search