This function returns the inverse of the F probability distribution.
F.INV.RT(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 = FDIST.RT(x,...), then FINV.RT(p,...) = x. The #VALUE! error value is returned if any argument is nonnumeric.
Accepts numeric data for all arguments. Returns numeric data.
F.INV.RT(A1,2,2)
F.INV.RT(R1C1,2,1)
F.INV.RT(0.021,5,3) gives the result 16.83979663538795
This function is available in Spread for Windows Forms 11.0 or later.
