Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

HYPGEOMDIST

Description: Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes and population size.

Syntax: HYPGEOMDIST(Sample_S,Number_Sample,Population_S,Number_Population)

Remarks:

where:

x = Sample_S

n = Number_Sample

M = Population_S

N = Number_Population

Example:

HYPGEOMDIST(1,4,8,20) = 0.363261

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.