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