Manuals/calci/FINV

FINV(prob,DF1,DF2)

Where prob is a probability associated with the F cumulative distribution.

DF1 is the numerator degrees of freedom and DF2 is the denominator degrees of freedom.

This function returns the inverse of the F probability distribution.

· Arguments should be numeric.

· Prob must be between 0 and 1

· When DF1is less than 1 or DF1is less than or equal to 10^10, and DF2 is less than 1 or DF2 is less than or equal to 10^10, FINV shows error value.

FINV

Syntax

Remarks

Examples

Description

Lets see an example,

FINV(prob,DF1,DF2)

B

0.01

8

6

=FINV(B2,B3,B4)