Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. the data is presented in parallel format. before r

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:

ThursdayFriday
MorningAfternoonMorningAfternoon
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=

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Week 3 Discussion: Creating a Work Breakdown Structure (WBS) * The project is building and opening...

Operations Management
Q

Q2: Which of the following statements about current is TRUE? 1. Current contains a neutral or no...

Electrical Engineering
Q

What is the Christian concept of the imago dei? How might it be relevant to health...

Psychology
Q

Which of the following determines the function of a protein molecule O The number of...

Biology
Q

A viewable screen of text is better than text that only can be read when...

Geometry
Q

Customer account "numbers" for a certain company consists of 4 letters followed by 3 single-digit...

Basic Math
Q

623.70 to the nearest cent

Accounting
Q

Since the SUTA rates changes are made at the end of each year, the available...

Accounting
Q

Exercise 6-11(Algo) Missing Data; Basic CVP Concepts [LO6-1, LO6-9] Fill in the missing amounts...

Accounting
Q

Portions of the financial statements for Myriad Products are provided below. MYRIAD PRODUCTS COMPANY Selected...

Accounting
Q

Can I get help figuring this out? Alan Fillmore's lifelong dream...

Accounting
Q

Down Payment and Loan Payments. Lucas wants to buy a used car that will cost...

Finance