# HYPGEOMDIST

## Content

This function returns the hypergeometric distribution.

## Syntax

`HYPGEOMDIST( x, n, M, N )`

## 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 |

## Remarks

The equation for this function is:

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-HYPGEOMDIST.png)

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`HYPGEOMDIST(A22,B23,62,1000)`

`HYPGEOMDIST(R22C11,R22C12,R34C14,R35C15)`

`HYPGEOMDIST(2,37,6,100)` gives the result 0.3327981975