This function returns the inverse of the F probability distribution.
F.INV(p,degnum,degden)
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 |
This function calculates the inverse of the F probability distribution, so if p = F.DIST(x,...), then F.INV(p,...) = x.
Accepts numeric data for all arguments. Returns numeric data.
F.INV(A1,2,2)
F.INV(R1C1,2,1)
F.INV(0.021,5,3) gives the result 0.11813305544967191
This function is available in Spread for Windows Forms 11.0 or later.