FINV
Syntax:
FINV ( probability , degrees-freedom-1 , degrees-freedom-2 )
Description: Computes the inverse of the F probability distribution. Given a value for probability, FINV
seeks that value x such that FDIST(
x, degrees-freedom1,
degrees-freedom2)
= probability. Thus, precision of FINV
depends on precision of FDIST
. FINV
uses an iterative search technique.
Arguments:
Name |
Type |
Description |
---|---|---|
probability |
number |
A probability associated with the F cumulative distribution. |
degrees-freedom-1 |
number |
The number of degrees of freedom for the numerator, truncated to an integer. |
degrees-freedom-2 |
number |
The number of degrees of freedom for the denominator, truncated to an integer. |
Return Type and Value: number – The inverse of the F probability distribution.
However, if
probability < 0 or probability > 1,
#NUM!
is returned.degrees-freedom-1 < 1 or degrees-freedom-1 ≥ 1010,
#NUM!
is returned.degrees-freedom-2 < 1 or degrees-freedom-2 ≥ 1010,
#NUM!
is returned.The search has not converged after some implementation-defined number of iterations,
#N/A
is returned