Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

NEGBINOMDIST

Description: Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be Number_F failures before the Number_S-th success, when the constant probability of a success is Probability_S. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.

Syntax: NEGBINOMDIST(Number_F, Number_S, Probability_S)

Remarks:

where x is Number_F, r is Number_S, and p is Probability_S.

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.