The data is presented in parallel format. Before running theANOVA in Excel, you will need to put it into serial (column)format. You will need to create a categorical variable for thefirst factor (days) and for the second factor (time of day). Thisis a critical step.
The data presented shows exam scores for students randomly assignedto the sections meeting on these days at these times of theday:
| Thursday | Friday |
|---|
| Morning | Afternoon | Morning | Afternoon |
|---|
15
46.9
39.6
45.2
28.5
45.6
15
47.5
28.1
39.3 | 47.1
34.4
27.8
49.2
61.4
48.9
27.8
33.8
61.3
47.2 | 26.8
46
46
46.1
46
38.4
27.6
59.5
59.5
38.4 | 23.6
35.6
40.9
32.3
40.8
41.2
32
41.4
35.2
22.9 |
Conduct a 2-way ANOVA. First, find the group means for eachlevel of the factors. (Report answers accurate to 2 decimalplaces.)
Days:
  MThursday=
  MFriday=
Time of day:
  Mmorning=
  Mafternoon=
Report the results of the ANOVA for the main & interactioneffects. (Report P-values accurate to 4 decimal places andF-ratios accurate to 3 decimal places.)
Day:
  FA=
  p=
Time of day:
  FB=
  p=
Interaction:
  FA×B=
  p=
