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 70.8 78.1 59 78.2 46.6 46.4 76.5 59.3 76.3 70 65.6 78.3 59.3 59.7 78.6 80.8 92.7 80.8 65.3 92.3 90.8 90.5 69.1 77.3 69 77.5 58.6 77.8 77.5 58.6 63.3 72.8 54.2 54.4 72.1 66.2 63 72.5 66 72.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: MThursday=MThursday= MFriday=MFriday= Time of day: Mmorning=Mmorning= Mafternoon=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=FA= p=p= Time of day: FB=FB= p=p= Interaction: FA×B=FA×B= p=p=
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 |
70.8 78.1 59 78.2 46.6 46.4 76.5 59.3 76.3 70 |
65.6 78.3 59.3 59.7 78.6 80.8 92.7 80.8 65.3 92.3 |
90.8 90.5 69.1 77.3 69 77.5 58.6 77.8 77.5 58.6 |
63.3 72.8 54.2 54.4 72.1 66.2 63 72.5 66 72.2 |
Conduct a 2-way ANOVA. First, find the group
Days:
MThursday=MThursday=
MFriday=MFriday=
Time of day:
Mmorning=Mmorning=
Mafternoon=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=FA=
p=p=
Time of day:
FB=FB=
p=p=
Interaction:
FA×B=FA×B=
p=p=
Step by step
Solved in 2 steps with 1 images