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.)

• Event analysis internal functions

• Event analysis resources

• References to any ReliaSoft Workbooks

Example:

• FINV(0.01,6,4) = 15.20686486.