FDIST

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

FDIST(value,degnum,degden)

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

Accepts numeric data for all arguments. Returns numeric data.

FDIST(A1,2,2)

FDIST(R1C1,2,1)

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

This function is available in product version 1.0 or later.