Microsoft Office Tutorials and References
In Depth Information
which formula is
used to calculate
FDIST returns the F probability distribution.
The FDIST function is used for analysis of variance, that is to determine if two data sets have
different degrees of diversity. This function returns the one-tailed probability of the FDIST
distribution. Figure 11.15 shows an example where the FDIST is approximately .025, the area in
the right tail under the FDIST distribution cur ve. This is the significance level . The significance
level represents the probability of rejecting the statement you assume is true (the null
hypothesis). In this case that probability is 2.5%.
Is the value at which to evaluate the function; must be a
Is the numerator of freedom.
Is the denominator of freedom.
FDIST returns the
probability of rejecting
the statement you
assume is true.