FINV
Name
F inverse
Description
Returns the inverse of the F probability distribution.
Syntax
FINV(p, degnum, degden)
Remarks
Arguments are as follows:
| 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.
This function calculates the inverse of the F probability distribution, so if p = FDIST(x,...), then FINV(p,...) = x..
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
FINV(A1,2,2) FINV(R1C1,2,1)
FINV(0.021,5,3)=16.83975