NEGBINOM.DIST
Category: Statistical Function.
Description: Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with probability_s probability of success.
Syntax: NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
The NEGBINOM.DIST function syntax has the following arguments:
Number_f: number of failures.
Number_s: threshold number of successes.
Probability_s: probability of a success.
Cumulative: logical value that determines the form of the function.
-
If cumulative is TRUE, NEGBINOM.DIST returns the cumulative distribution function.
-
If FALSE, NEGBINOM.DIST returns the probability density function.