Excel Function : NEGBINOMDIST
Category
Compatibility
Description
Returns the negative binomial distribution
Microsoft Excel Reference Page
https://support.office.com/en-us/article/NEGBINOMDIST-function-f59b0a37-bae2-408d-b115-a315609ba714
Syntax and Description of the NEGBINOMDIST Excel Function
Negative binomial distribution is a probability distribution that is used to calculate the probability of observing a given number of successes in a negative binomial experiment, given a certain number of trials and a probability of success in a single trial. The negative binomial distribution is a generalization of the binomial distribution, and is often used to model events that occur in a sequence of independent trials, where the probability of success in each trial is not constant, but instead varies from trial to trial.
About NEGBINOMDIST Excel Function
The syntax for the NEGBINOMDIST Excel function is as follows: NEGBINOMDIST(x, number_f, probability_s) The NEGBINOMDIST function returns the negative binomial distribution. The negative binomial distribution is a probability distribution that is often used to model the number of failures in a given number of trials, where the probability of success is constant.