The data is presented in parallel format. Before running the ANOVA in Excel, you will need...

90.2K

Verified Solution

Question

Statistics

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=

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

Answer & Explanation Solved by verified expert

3.9 Ratings (670 Votes)

using exceldatadata analysistwo way ANOVA we have Anova TwoFactor With Replication SUMMARY Morning Afternoon Total Thursday Count 10 10 20 Sum 3507 4389 7896 Average 3507 4389 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member