[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

FDIST(12.345,3,4) results in 0.017226183

end example]