NEGBINOM.DIST function
Summary
Returns the negative binomial distribution
Syntax
NEGBINOM.DIST(number_f,number_s,probability_s,cumulative)
The NEGBINOM.DIST function syntax has the following arguments:
• Number_f Required. The number of failures.
• Number_s Required. The threshold number of successes.
• Probability_s Required. The probability of a success.
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NEGBINOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
• Number_f Required. The number of failures.
• Number_s Required. The threshold number of successes.
• Probability_s Required. The probability of a success.
• Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NEGBINOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
Example
=NEGBINOM.DIST(A2,A3,A4,TRUE)
=NEGBINOM.DIST(A2,A3,A4,FALSE)
=NEGBINOM.DIST(A2,A3,A4,FALSE)