Spread Formula Reference
NEGBINOMDIST
Formula Functions > Functions M to Q > NEGBINOMDIST

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