In This Topic

HYPGEOM.DIST

In This Topic

This function returns the hypergeometric distribution.

HYPGEOM.DIST(*x*,*n*,*M*,*N,cumulative*)

The arguments are as follows, and are truncated if not integers:

Argument | Description |
---|---|

x |
An integer representing the number of successes in the sample |

n |
An integer representing the size of the sample |

M |
An integer representing the number of successes in the population |

N |
An integer representing the size of the population |

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

If any argument is nonnumeric, the function returns the #VALUE! error value.

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

HYPGEOM.DIST(A22,B23,62,1000,C10)

HYPGEOM.DIST(R22C11,R22C12,R34C14,R35C15,R10C5)

HYPGEOM.DIST(2,37,6,100,200) gives the result 0.6079646750428083

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