Skip to main content

FINV - script and chart function

ON THIS PAGE

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:  

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.