FDIST

Syntax:

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: