FINV - script and chart function

FINV() returns the inverse of the F-probability distribution.

Syntax:  

FINV(prob, degrees_freedom1, degrees_freedom2)

Return data type: number

Arguments:  

Argument Description
prob A probability associated with the F-probability distribution and must be a number between 0 and 1.
degrees_freedom An integer stating the number of degrees of freedom.

This function is related to the FDIST function in the following way:
If prob = FDIST(value, df1, df2), then FINV(prob, df1, df2) = value

Limitations:  

All arguments must be numeric, else NULL will be returned.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?