This function calculates the F probability distribution, to see degrees of diversity between two sets of data.
F.DIST.RT(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 |
The #VALUE! error value is returned if any argument is nonnumeric.
Accepts numeric data for all arguments. Returns numeric data.
F.DIST.RT(A1,2,2)
F.DIST.RT(R1C1,2,1)
F.DIST.RT(16.83975,5,3) gives the result 0.021000082461949843
This function is available in Spread for Windows Forms 11.0 or later.