NEGBINOMDIST

NEGBINOMDIST probability mass function of the negative binomial distribution

Synopsis

NEGBINOMDIST(f,t,p)

Arguments

f: number of failures

t: threshold number of successes

p: probability of a success

Note

If f or t is a non-integer it is truncated. If (f + t -1) <= 0 this function returns a #NUM! error. If p < 0 or p > 1 this functions returns a #NUM! error.

Microsoft Excel Compatibility

This function is Excel compatible.