Skip to main content Skip to complementary content

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 page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!