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.