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 ?=0.05?=0.05 with dfbetween=5dfbetween=5 and dfwithin=78dfwithin=78, enter

=FINV(0.05,5,78)

Enter this into Excel to confirm you obtain the value 2.332.

You conduct a one-factor ANOVA with 8 groups and 7 subjects in each group (a balanced design). Use Excel to find the critical values for ?=0.1?=0.1 and ?=0.02?=0.02 (report accurate to 3 decimal places).
F0.1=F0.1=  
F0.02=F0.02=

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 dwithin78, enter FINV O.05,5,78) Enter this into Excel to confirm you obtain the value 2.332 You conduct a one-factor ANOVA with 8 groups and 7 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). F0.1 =

Explanation / Answer

We have a one factor Anova with 8 groups and 7 subjects in each group.

K=8

N=8*7 = 56

dfbetween=K-1=7

dfwithin=N-K = 56-8 = 48

F0.1   = FINV(0.1,7,48)=1.846

F0.02 =FINV(0.02,7,48)=2.679

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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