NEGBINOM.DIST Function Explained
The NEGBINOM.DIST Function in Microsoft Excel calculates the negative binomial distribution, which is the probability of a given number of successes in a sequence of independent Bernoulli trials, given the probability of success in each trial and the number of successes. It takes three arguments: the number of successes, the probability of success in each trial, and the number of trials.
NEGBINOM.DIST Function Syntax
NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
- number_f: The number of failures that are observed.
- number_s: The number of successes that are required.
- probability_s: The probability of success on each trial.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, NEGBINOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.