# HYPGEOM.DIST

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the hypergeometric distribution.

## Syntax

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

## Arguments

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 |

## Remarks

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

## Data Types

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

## Examples

`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

## Version Available

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

## See Also

[HYPGEOMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHYPGEOMDIST)