The F.INV function in Excel computes the inverse of the Cumulative F Distribution with a given probability.
Syntax :
=F.INV( probability, deg_freedom1, deg_freedom2 )
Parameters :
probability –
deg_freedom1 –
deg_freedom2 –
Example :
The right figure depicts the inverse of the Cumulative F Distribution, with the numerator degrees of freedom equal to 2 and the denominator degrees of freedom equal to 5. If you wish to determine the value of this function with a probability of 0.9, use the Excel F.Inv function, as shown below.
Ask Your Query