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:

Example:

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