Statistical - NEGBINOM.DIST Function

Description

The NEGBINOM.DIST function returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success.

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 to be independent.

Syntax

NEGBINOM.DIST (number_f,number_s,probability_s,cumulative)

Arguments

Argument	Description	Required/ Optional
Number_f	The number of failures.	Required
Number_s	The threshold number of successes.	Required
Probability_s	The probability of a success.	Required
Cumulative	A logical value that determines the form of the function. If cumulative is TRUE, NEGBINOM.DIST returns the cumulative distribution function. If cumulative is FALSE, NEGBINOM.DIST returns the probability density function.	Required

Notes

The equation for the negative binomial distribution is −

$$nb\left ( x;r,p \right )=\begin{pmatrix} x+r-1\\ r-1\end{pmatrix}{p}'\left ( 1-p \right )^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 the number_f, number_s, or probability_s arguments are not recognized as numeric values, NEGBINOM.DIST returns the #VALUE! error value.
If the cumulative argument is not recognized as a numeric or a logical value, NEGBINOM.DIST returns the #VALUE! error value.
If probability_s < 0 or if probability > 1, NEGBINOM.DIST returns the #NUM! error value.
If number_f < 0 or number_s < 1, NEGBINOM.DIST returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm