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