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