Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

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.

Example:

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