FInv() returns the inverse of the F-probability distribution.
Syntax:
FInv(prob, degrees_freedom1, degrees_freedom2)
Return data type: number
Arguments:
| Argument | Description |
|---|---|
| prob | A probability associated with the F-probability distribution and must be a number between 0 and 1. |
| degrees_freedom | An integer stating the number of degrees of freedom. |
This function is related
to the FDist function in the following way:
If prob = FDist(value, df1, df2),
then FInv(prob, df1, df2) = value
Limitations:
All arguments must be numeric, else NULL will be returned.
Examples and results:
| Example | Result |
|---|---|
| FInv( 0.0019369, 8, 6) | Returns 15.0000 |
