Microsoft Office Tutorials and References
In Depth Information
FDIST
Figure 11.14
The cumulative
argument dictates
which formula is
used to calculate
EXPONDIST .
FDIST
FDIST returns the F probability distribution.
=FDIST(x,degrees_freedom1,degrees_freedom2)
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%.
X
Is the value at which to evaluate the function; must be a
nonnegative number.
Is the numerator of freedom.
DEGREES FREEDOM1
Is the denominator of freedom.
DEGREES FREEDOM2
Figure 11.15
FDIST returns the
probability of rejecting
the statement you
assume is true.
Search JabSto ::




Custom Search