NEGBINOMDIST(number_f, number_s, probability_s)

Returns the probability of getting less than or equal to a particular value in a negative binomial distribution (no cumulative).

number_fThe number of failures.
number_sThe threshold number of successes.
probability_sThe probability of a success.

Remarks

* NEGBINOM.DIST was added in Excel 2010 to replace this function.
* This function 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".
* For example, you need to find 10 people with excellent reflexes, and you know the probability that a candidate has these qualifications is 0.3.
* This function calculates the probability that you will interview a certain number of unqualified candidates before finding all 10 qualified candidates.
* The "number_f" and "number_s" are truncated to integers.
* If any of the arguments are not numeric, then #VALUE! is returned
* If "probability_s" < 0, then #NUM! is returned.
* If "probability_s" > 1, then #NUM! is returned.
* If ("number_f" + "number_s" - 1) = 0, then #NUM! is returned.
* The equation for the negative binomial distribution is: ??
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

 A
1=NEGBINOMDIST(0,1,0.25) = 0.25
2=NEGBINOMDIST(0,1,0.5) = 0.5
3=NEGBINOMDIST(1,6,0.5) = 0.047
4=NEGBINOMDIST(10,5,0.25) = 0.055
5=NEGBINOMDIST(10,5,-4) = #NUM!
6=NEGBINOMDIST(10,"some text",0.25) = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top