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 begin 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:

ThursdayFridayMorningAfternoonMorningAfternoon44.5

46.3

38

46.1

27.2

27.1

14.1

14.4

43.8

38.433.1

27

46

59.8

60.3

47.7

46.4

47.8

33.4

27.245.3

36.8

58.2

44.8

57.7

36.9

45.4

26.3

26.3

45.340.3

30.7

22.2

31

34

22.2

33.7

39.8

39.9

40.2

Conduct a 2-way ANOVA.First, find the group means for each level of the factors.(Report answers accurate to 2 decimal places.)

Days:

M

Thursday

=

MThursday=

M

Friday

=

MFriday=

Time of day:

M

morning

=

Mmorning=

M

afternoon

=

Mafternoon=

Report the results of the ANOVA for the main & interaction effects.(ReportP-values accurate to 4 decimal places andF-ratios accurate to 3 decimal places.)

Day:

F

A

=

FA=

p

=

p=

Time of day:

F

B

=

FB=

p

=

p=

Interaction:

F

A

B

=

FAB=

p

=

p=