Related Topics: | ||
Description: Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x.
Syntax: FINV(Probability, Deg_Freedom1, Deg_Freedom2)
Probability is a probability associated with the F cumulative distribution.
Deg_Freedom1 is the numerator degrees of freedom.
Deg_Freedom2 is the denominator degrees of freedom.
Remarks:
All arguments must be numerical.
Probability must be >= 0 and <= 1.
Both Deg_Freedom1 and Deg_Freedom2 must be an integer.
Deg_Freedom1and Deg_Freedom2 must be >= 1 and < 10^10.
Example:
FINV(0.01,6,4) = 15.20686486.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.