NEGBINOM.DIST

Formulas / NEGBINOM.DIST
Calculate the negative binomial distribution.
=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
  • number_f - the number of failures
  • number_s - the threshold number of successes
  • probability_s - the probability of a success
  • cumulative - determines the form of the function

Examples

  • =NEGBINOM.DIST(A2,A3,A4,TRUE)

    The NEGBINOM.DIST function can be used to calculate the cumulative negative binomial distribution. In this example, we will calculate the cumulative negative binomial distribution for the terms in cells A2, A3, and A4. To do this, we will use the formula above. This formula will calculate the cumulative negative binomial distribution for the three cells.

  • =NEGBINOM.DIST(10,10,0.5,FALSE)

    The NEGBINOM.DIST function can also be used to calculate the probability of a certain number of successes in a given number of trials. In this example, we will calculate the probability that there are 10 successes in 10 trials. To do this, we will use the formula above. This formula will calculate the probability of 10 successes in 10 trials given a probability of 0.5 for each trial.

  • =NEGBINOM.DIST(5, 10, 0.2, FALSE)

    The NEGBINOM.DIST function can also be used to calculate the probability of a certain number of failures in a given number of trials. In this example, we will calculate the probability that there are 5 failures in 10 trials. To do this, we will use the formula above. This formula will calculate the probability of 5 failures in 10 trials given a probability of 0.2 for each trial.


Summary

The NEGBINOMDIST function calculates the probability of a given number of successes in a sequence of independent trials, where the number of successes is fixed, and the number of trials is variable.

  • The negative binomial distribution is used in financial analysis to estimate the probability of getting a return from a stock or portfolio before getting a negative return.
  • The NEGBINOM.DIST function in Sourcetable calculates the probability of the negative binomial distribution.

Frequently Asked Questions

What is the NEGBINOM.DIST function?
The NEGBINOM.DIST function calculates the negative binomial distribution. This is the probability that there will be a given number of failures before the given number of successes.
How is the NEGBINOM.DIST function different from the binomial distribution?
The NEGBINOM.DIST function is similar to the binomial distribution, but the number of successes is fixed and the number of trials is variable. The trials are also assumed to be independent.
What parameters do I need to use the NEGBINOM.DIST function?
The parameters required to use the NEGBINOM.DIST function are the number of successes, the probability of success, and the number of trials.
How do I calculate the negative binomial distribution?
The negative binomial distribution is calculated using the NEGBINOM.DIST function, which takes the following parameters as inputs:
  • Number of successes
  • Probability of success
  • Number of trials
The output of the function is the probability that there will be a given number of failures before the given number of successes.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV