Inverse of F-probability distribution

Returns the inverse of the F probability distribution. This function is used to return critical values from the F distribution. For example, the output of an analysis-of-variation (anova) calculation may include data for F-statistic, F-probability, and F-critical values at the 0.05 level of significance. In such cases, the significance level can be used as the probability argument for FINV to return the critical value of F.

For information on the F probability distribution function, see FDistribution (f-probability distribution).

Syntax

InverseFDistribution (x, df1, df2)

Where:

x is the probability associated with the F right-tailed distribution.

df1 represents the degrees of freedom of numerator values.

df2 represents the degrees of freedom of denominator values.

Usage Notes

If df1 or df2 is not an integer, it is truncated.

The following conditions are invalid:

• An argument is nonnumeric
• x< 0 or x > 1
• df1 < 1
• df2 < 1