Spread.Sheets Documentation
FDIST
Spread.Sheets Documentation > Formula Reference > Formula Functions > 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

See Also