Spread Formula Reference
Formula Functions / Functions H to L / HYPGEOM.DIST
In This Topic
    HYPGEOM.DIST
    In This Topic

    This function returns the hypergeometric distribution.

    Syntax

    HYPGEOM.DIST(x,n,M,N,cumulative)

    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
    cumulative A logical value that determines the form of the function. If cumulative is TRUE, then this function returns the cumulative distribution function; if this argument is FALSE, it returns the probability mass function

    Remarks

    If any argument is nonnumeric, the function returns the #VALUE! error value.

    Data Types

    Accepts numeric data for all arguments except cumulative. Returns numeric data.

    Examples

    HYPGEOM.DIST(A22,B23,62,1000,C10)

    HYPGEOM.DIST(R22C11,R22C12,R34C14,R35C15,R10C5)

    HYPGEOM.DIST(2,37,6,100,200) gives the result 0.6079646750428083

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    HYPGEOMDIST