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 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
)

OK

Save this ﬁle 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 ﬁle as: BEE12

Print out both the data table and the ANOVA summary table so that all of this

information ﬁts 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