Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TWO FACTOR ANOVA WITH REPLICATION Source of Variation SS df MS F p-value Factor A 36,598.56 3 12,199.52 Factor B 22,710.29 2 11,355.15 Interaction 177,015.38
TWO FACTOR ANOVA WITH REPLICATION
Source of Variation | SS | df | MS | F | p-value |
Factor A | 36,598.56 | 3 | 12,199.52 |
|
|
Factor B | 22,710.29 | 2 | 11,355.15 |
|
|
Interaction | 177,015.38 | 6 | 29,502.56 |
|
|
Error | 107,561.25 | 36 | 2,987.81 |
|
|
|
|
|
| ||
Total | 343,885.48 | 47 |
|
Calculate each F test statistic and the p-value for each F test using Excel's function .DIST.RT(F,DF1,DF2).
(Round your Fcalc values to 3 decimal places and p-values to 4 decimal places.)
Source of Variation Fcalc p-value
Factor A
Factor B
Interaction
Please show all steps including numbers inputted inExcel formula.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started