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\displaystyle \alpha={0.05} with dfbetween=3\displaystyle {d}{f}_{{\text{between}}}={3} and dfwithin=20\displaystyle {d}{f}_{{\text{within}}}={20}, 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 α=0.05\displaystyle \alpha={0.05} and α=0.02\displaystyle \alpha={0.02} (report accurate to 3 decimal places).
F0.05=\displaystyle {F}_{{0.05}}=
F0.02=\displaystyle {F}_{{0.02}}=