NEGBINOMDIST

Definition: NEGBINOMDIST is a function that returns the negative binomial distribution of a given set of data.

Syntax: =NEGBINOMDIST(number_f, number_s, probability_s)

Situation: This formula is appropriate when you need to calculate the negative binomial distribution of a given set of data.

Example: If you want to find the probability of getting the second success on the 4th trial given that the success probability is 0.2, the formula =NEGBINOMDIST(2, 4, 0.2) can be used, which returns 0.1536.