FDIST ( x , degrees-freedom-1 , degrees-freedom-2 )

Description: Computes the F probability distribution.

Mathematical Formula:

FDIST=P(F>x), where F is a random variable that has an F distribution with degrees-freedom-1 and degrees-freedom-2 degrees of freedom.

Arguments:

Name	Type	Description
x	number	The value at which the function is to be evaluated.
degrees-freedom-1	number	The number of degrees of freedom for the numerator, truncated to an integer.
degrees-freedom-2	number	The number of degrees of freedom for the denominator, truncated to an integer.

Return Type and Value: number – The F probability distribution.

However, if

• x is negative, #NUM! is returned.

• degrees-freedom-1 < 1 or degrees-freedom-1 ≥ 1010, #NUM! is returned.

• degrees-freedom-2 < 1 or degrees-freedom-2 ≥ 1010, #NUM! is returned.

[Example:

FDIST(12.345,3,4) results in 0.017226183

end example]