Excel Function : NEGBINOMDIST

Download now!

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.