Spread 8.0 Documentation
HYPGEOMDIST
Support Options
Formula Reference > Built-In Functions > HYPGEOMDIST

Glossary Item Box

HYPGEOMDIST


Name

Hypergeometric distribution

Description

Returns the hypergeometric distribution.

Syntax

HYPGEOMDIST(x,n,M,N)

Remarks

The arguments are truncated if not integers.

This function has the following arguments:

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

The equation for this function is:Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

HYPGEOMDIST(A22,B23,62,1000)
HYPGEOMDIST(R22C11,R22C12,R34C14,R35C15)
HYPGEOMDIST(2,37,6,100)=0.3327981975

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.