Calculates the probability of getting 'x' failures before reaching the r
th
success for independent trials with the probability of success 'p'.
Syntax
x: The number of failures to obtain probability for. Eg., 10
r: The number of successes to take. Eg., 15
Examples
Formula
|
Result
|
=NEGBINOMDIST(A2;B2;C2)
|
0.000001819
|
=NEGBINOMDIST(A3;B3;C3)
|
0.007981276
|
=NEGBINOMDIST(A4;B4;C4)
|
0.013885498
|
Possible Errors
Errors
|
Meaning
|
#N/A!
|
|
#NAME!
|
|
#VALUE!
|
|
#REF!
|
|
#NUM!
|
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com