Excel can be used to find the probability of obtaining a given F-ratio or one more extreme (calculates the area under the curve to the left of the value).  The function requires the F-ratio, the degrees of freedom for the numerator and the degrees of freedom for the denominator (entered in that order).

For our example, we will use F=2.61\displaystyle {F}={2.61}, dfbetween=3\displaystyle {d}{f}_{{\text{between}}}={3} and dfwithin=24\displaystyle {d}{f}_{{\text{within}}}={24}.
=FDIST(2.61,3,24)
Enter this into Excel to confirm you obtain the value 0.07476.


You conduct a one-factor ANOVA with 5 groups and 10 subjects in each group (a balanced design) and obtain F=2.9\displaystyle {F}={2.9}.  Use Excel to find the requested values (report accurate to 4 decimal places).
dfbetween=\displaystyle {d}{f}_{{\text{between}}}=
dfwithin=\displaystyle {d}{f}_{{\text{within}}}=
p=\displaystyle {p}=