- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Compatibility - NEGBINOMDIST Function
The NEGBINOMDIST function replaces the NEGBINOM.DIST function in Excel 2010.
Description
The function returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s.
This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed independent.
Syntax
NEGBINOMDIST (number_f,number_s,probability_s)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Numbre_f | The number of failures. | Required |
| Number_s | The threshold number of successes. | Required |
| Probability_s | The probability of a success. | Required |
Notes
The equation for the negative binomial distribution is −
$$nb(x;r,p) = \binom{x+r-1}{r-1}p^r(1-p)^n$$
Where −
x is number_f, r is number_s, and p is probability_s.
Number_f and number_s are truncated to integers.
If any argument is nonnumeric, NEGBINOMDIST returns the #VALUE! error value.
If probability_s < 0 or if probability > 1, NEGBINOMDIST returns the #NUM! error value.
If number_f < 0 or number_s < 1, NEGBINOMDIST returns the #NUM! error value.
Example
