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

    This function returns the negative binomial distribution.

    Syntax

    NEGBINOMDIST(x,r,p)

    Arguments

    This function has these arguments:

    Argument Description
    x An integer representing the number of failures in trials
    r An integer representing the threshold number of successes
    p Probability of success on each trial A number between 0 and 1.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    NEGBINOMDIST(B1,C15,0.335)

    NEGBINOMDIST(R1C2,R15C3,0.75)

    NEGBINOMDIST(4,13,0.85) gives the result 0.111399299

    See Also