NEGBINOMDIST Function Explained
The NEGBINOMDIST 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.
NEGBINOMDIST Function Syntax
NEGBINOMDIST(number_f, number_s, probability_s)
- 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.