Formulas > =NEGBINOM.DIST()
How to Use NEGBINOM.DIST() in Google Sheets
Description
How To Actually Use NEGBINOM.DIST() in Sheets
NEGBINOM.DIST(num_failures, num_successes, prob_success)
Try NEGBINOM.DIST yourself
In cells A1:A5, enter the number of failures. In cells B1:B5, enter the number of successes. In cell C1, use the NEGBINOM.DIST formula to calculate the probability of getting 3 failures before 2 successes with a success probability of 0.5.
Hints (2)
-
Remember to input the number of failures, successes, and the probability of success.
-
Make sure to use the correct order of arguments for the NEGBINOM.DIST function.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the NEGBINOM.DIST() formula:
Generate a NEGBINOM.DIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NEGBINOM.DIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NEGBINOM.DIST() formula