IPS 4/e Exercise 12.30 Response of beetles to colors p. 789
Number of insects trapped on each color of board
Lemon
Yellow White Green Blue
45 21 37 16
59 12 32 11
48 14 15 20
46 17 25 21
38 13 39 14
47 17 41 7
Means 47.167 15.667 31.5 14.833
Std. Devs. 6.7946 3.3267 9.9146 5.3448
Excel command:  : Tools--Data Analysis…--Anova:  Single Factor
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Yellow 6 283 47.16667 46.16667
White 6 94 15.66667 11.06667
Green 6 189 31.5 98.3
Blue 6 89 14.83333 28.56667
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 4218.458 3 1406.153 30.55193 1.15E-07 3.098393
Within Groups 920.5 20 46.025
Total 5138.958 23