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 with and , enter
=FINV(0.05,3,20)
Enter this into Excel to confirm you obtain the value 3.098.
You conduct a one-factor ANOVA with 8 groups and 9 subjects in each group (a balanced design). Use Excel to find the critical values for and (report accurate to 3 decimal places).
You conduct a one-factor ANOVA with 8 groups and 9 subjects in each group (a balanced design). Use Excel to find the critical values for and (report accurate to 3 decimal places).
- Question Help:
- Written Example