In: Math
A researcher examined whether the time of day someone exercises affects memory retention in college courses. Participants were assigned to one of three exercise groups: morning, afternoon, evening, and their performance on a memorization task was measured. This data is below:
| Morning | Afternoon | Evening |
| 6 | 4 | 7 |
| 7 | 5 | 6 |
| 8 | 6 | 8 |
| 5 | 4 | 6 |
| 6 | 5 | 5 |
| Mean = 6.40 | Mean = 4.80 | Mean = 6.40 |
| s = 1.14 | s =.84 | s = 1.14 |
Assuming the researcher wants to know whether the performance was different in these groups (alpha = .05). What is the Sum of Squares Between (SSB)? Round to two decimal places.
Solution:
Install analysis tool pack in excel and then perform one way ANOVA
data >data analysis>anova single factor

You get
| Anova: Single Factor | ||||||
| SUMMARY | ||||||
| Groups | Count | Sum | Average | Variance | ||
| Morning | 5 | 32 | 6.4 | 1.3 | ||
| Afternoon | 5 | 24 | 4.8 | 0.7 | ||
| Evening | 5 | 32 | 6.4 | 1.3 | ||
| ANOVA | ||||||
| Source of Variation | SS | df | MS | F | P-value | F crit |
| Between Groups | 8.533333 | 2 | 4.266667 | 3.878788 | 0.050198 | 3.885294 |
| Within Groups | 13.2 | 12 | 1.1 | |||
| Total | 21.73333 | 14 | ||||
Sum of Squares Between ,SSB=8.53