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 , and .
=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 . Use Excel to find the requested values (report accurate to 4 decimal places).
For our example, we will use , and .
You conduct a one-factor ANOVA with 5 groups and 10 subjects in each group (a balanced design) and obtain . Use Excel to find the requested values (report accurate to 4 decimal places).