Question

The data is presented in parallel format. Before running the ANOVA in Excel, you will need to put it into serial (column) format. You will need to create a categorical variable for the first factor (days) and for the second factor (time of day). This is a critical step.

The data presented shows exam scores for students randomly assigned to the sections meeting on these days at these times of the day:

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 each level of the factors. (Report answers accurate to 2 decimal places.)
Days:
  MThursday=
  MFriday=
Time of day:
  Mmorning=
  Mafternoon=

Report the results of the ANOVA for the main & interaction effects. (Report P-values accurate to 4 decimal places and F-ratios accurate to 3 decimal places.)
Day:
  FA=
  p=
Time of day:
  FB=
  p=
Interaction:
  FA×B=
  p=

Answer 1

using excel>data>data analysis>two way ANOVA

we have

Anova: Two-Factor With Replication
SUMMARY	Morning	Afternoon	Total
Thursday
Count	10	10	20
Sum	350.7	438.9	789.6
Average	35.07	43.89	39.48
Variance	160.4134	154.8788	169.8206
Friday
Count	10	10	20
Sum	434.3	345.9	780.2
Average	43.43	34.59	39.01
Variance	124.5757	48.80322	102.6915
Total
Count	20	20
Sum	785	784.8
Average	39.25	39.24
Variance	153.3868	119.2415
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
A	2.209	1	2.209	0.018082	0.893781	4.113165
B	0.001	1	0.001	8.19E-06	0.997733	4.113165
A*B	779.689	1	779.689	6.382117	0.016067	4.113165
Within	4398.04	36	122.1678
Total	5179.939	39

Days:
  MThursday=39.48
  MFriday=39.01
Time of day:
  Mmorning=39.25
  Mafternoon=39.24

Report the results of the ANOVA for the main & interaction effects. (Report P-values accurate to 4 decimal places and F-ratios accurate to 3 decimal places.)
Day:
  FA=0.018
  p=0.8938
Time of day:
  FB=0.000
  p=0.9977
Interaction:
  FA×B=6.382
  p=0.0161