NEGBINOMDIST

Syntax:

NEGBINOMDIST ( number-failures , number-successes , success-probability )

Description: Computes the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number-failures failures before the number-successesth success, when the constant probability of a success is success-probability.

Mathematical Formula:

where:

x is number-failures, r is number-successes, and p is success-probability.

Arguments:

Name

Type

Description

number-failures

number

The number of failures, truncated to integer.

number-successes

number

The threshold number of successes, truncated to integer.

success-probability

number

The probability of a success.

Return Type and Value: number – The negative binomial distribution.

However, if

  • number-failures < 0 or number-successes < 1, #NUM! is returned.

  • success-probability < 0 or success-probability > 1, #NUM! is returned.

example: