Manuals/calci/FINV
Jump to navigation
Jump to search
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)
| Column1 | Column2 | Column3 | ||
| Row1 | 0.01 | |||
| Row2 | 8 | |||
| Row3 | 6 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
