# HYPGEOMDIST

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

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:
![HYPGEOMDIST Equation](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/artwork/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

## Version Available

This function is available in product version 1.0 or later.

## See Also

[BINOMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionBINOMDIST) \| [GAMMADIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionGAMMADIST) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)