Spread Formula Reference
FDIST
Formula Functions > Functions D to G > FDIST

This function calculates the F probability distribution, to see degrees of diversity between two sets of data.

Syntax

FDIST(value,degnum,degden)

Arguments

This function has these arguments:

Argument Description
value Value at which to evaluate the function
degnum Number of degrees of freedom for the numerator; if not an integer, the number is truncated
degden Number of degrees of freedom for the denominator; if not an integer, the number is truncated

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

FDIST(A1,2,2)

FDIST(R1C1,2,1)

FDIST(16.83975,5,3) gives the result 0.021

Version Available

This function is available in product version 1.0 or later.

See Also

FINV | Statistical Functions