Microsoft Office Tutorials and References
In Depth Information
Fig. 8.1 Worksheet Data for
Honey Bees (Practical
example)
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
A6: 14.2
C17: 18
Enter the other information into your spreadsheet table. When you have finished
entering these data, the last cell on the left should have 17.8 in cell A16, and the
last cell on the right should have 18 in cell C17. Center the numbers in each of the
columns.
Important note:
Be sure to double-check all of your figures in the table to make
sure that they are exactly correct or you will not be able to
obtain the correct answer for this problem!
Save this file as: BEE10
8.1 Using Excel to Perform a One-Way Analysis
of Variance (ANOVA)
Objective: To use Excel to perform a one-way ANOVA test.
Search JabSto ::




Custom Search