Navigation:  Formula Reference > Spreadsheet Formula Functions >

HYPGEOMDIST

Previous pageReturn to chapter overviewNext page

 

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:

Func-HYPGEOMDIST

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

 

See Also

BINOMDIST

GAMMADIST