Excel can be used to find the critical value for an F distribution for a given s

Question

Excel can be used to find the critical value for an F distribution for a given significance level. For example, to find the critical value (the value above which you would reject the null hypothesis) for a 0.05 with dfbetween 4 and dwithin 40, enter =F INV (0.05 , 4 ,40) Enter this into Excel to confirm you obtain the value 2.606 You conduct a one-factor ANOVA with 7 groups and 6 subjects in each group (a balanced design). Use Excel to find the critical values for a 0.1 and a 0.02 (report accurate to 3 decimal places). Fo.02

Explanation / Answer

here df(numerator) =7-1=6

df(denominator)=k(n-1)=7*(6-1)=35

from excel function F0.1 =finv(0.1,6,35)=1.950

F0.02 =finv(0.1,6,35)=2.934

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.