The following information applies to the questions displayed

[The following information applies to the questions displayed below.]

Calculate each F test statistic and the p-value for each F test using Excel\'s function = FDIST(F,DF1,DF2). (Round your F_calc values to 3 decimal places and p-values to 4 decimal places.)

ANOVA
Source of Variation	SS	df	MS	F	p-value
Factor A	44,461.64	3	14,820.55
Factor B	28,337.03	2	14,168.52
Interaction	104,497.98	6	17,416.33
Error	174,744.79	36	4,854.02
Total	352,041.44	47
(b) Calculate each F test statistic and the p-value for each F test using Excel\'s function = FDIST(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

Solution

Source of Variation F-calc p-value Factor A 3.0532 0.0407 Factor B 2.9189 0.0669 Interaction 3.588 0.0069