This function returns the inverse of the F probability distribution.
Syntax
FINV(p,degnum,degden)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| p | Probability associated with the F cumulative distribution |
| degnum | Number of degrees of freedom for the numerator; if not an integer, the number is truncated |
| degden | Number of degrees of freedom for the denominator; if not an integer, the number is truncated |
If either degnum or degden is not an integer, it is truncated.
Remarks
This function calculates the inverse of the F probability distribution, so if p = FDIST(x,...), then FINV(p,...) = x.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
FINV(A1,2,2)
FINV(R1C1,2,1)
FINV(0.021,5,3) gives the result 16.83975
Version Available
This function is available in product version 1.0 or later.