Question

PLEASE SHOW HOW TO DO IT IN EXCEL!!!!

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
18.6 42.3 31.4 31.6 50.8 49.1 43.1 50.7 49.1 18.5	50.3 31.5 52.9 37.8 52.4 64.6 64.3 50.9 32 37.3	41.4 49.7 30.9 41.3 49.8 62.5 63 30.7 49.8 49.6	38.5 26.9 38.6 44.7 26.5 45.1 35.3 44.6 35.9 44.3

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