Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / 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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    BINOMDIST | HYPGEOMDIST | Statistical Functions