SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / 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