The NEGBINOMDIST function returns the negative binomial distribution. All arguments are number values.
NEGBINOMDIST(f-num, s-num, prob-success)
f-num: The number of failures. f-num must be greater than or equal to 0.
s-num: The number of successful trials or tests. s-num must be greater than or equal to 1.
prob-success: The probability of success for each trial or test. prob-success must be greater than 0 and less than 1.
Notes
NEGBINOMDIST returns the probability that there will be a specified number of failures, f-num, before the specified number of successes, s-num. The constant probability of a success is prob-success.
Example |
|---|
=NEGBINOMDIST(3, 68, 0.95) returns 0.20913174716192. |