SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / HYPGEOMDIST
In This Topic
    HYPGEOMDIST
    In This Topic

    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

    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