In This Topic

F.DIST

In This Topic

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

F.DIST(*value*,*degnum*,*degden,cumulative*)

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 |

cumulative |
A logical value that determines the form of the function. If cumulative is TRUE, this function returns the cumulative distribution function; if FALSE, it returns the probability density function |

Accepts numeric data for all arguments except *cumulative*. Returns numeric data.

F.DIST(A1,2,2,TRUE)

F.DIST(R1C1,2,1,TRUE)

F.DIST(16.83975,5,3,TRUE) gives the result 0.9789999175380504

This function is available in Spread for Windows Forms 11.0 or later.