FINV
Description: Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x.
Syntax: FINV(Probability, Deg_Freedom1, Deg_Freedom2)
- Probability is a probability associated with the F cumulative distribution.
- Deg_Freedom1 is the numerator degrees of freedom.
- Deg_Freedom2 is the denominator degrees of freedom.
Remarks:
- All arguments must be numerical.
- Probability must be >= 0 and <= 1.
- Both Deg_Freedom1 and Deg_Freedom2 must be an integer.
- Deg_Freedom1and Deg_Freedom2 must be >= 1 and < 10^10.
- When used in an event analysis flowchart, the parameters must evaluate to numerical values. They can include:
-
Numerical values
-
Standard operands (+, -, *, /)
-
Predefined mathematical functions (exp, log, sin, etc.)
-
References to any ReliaSoft Workbooks
Example:
- FINV(0.01,6,4) = 15.20686486.