Formulas > =NEGBINOMDIST()
How to Use NEGBINOMDIST() in Google Sheets
Description
How To Actually Use NEGBINOMDIST() in Sheets
NEGBINOMDIST(num_failures, num_successes, prob_success)
Try NEGBINOMDIST yourself
In cells A1:A3, enter the number of failures, number of successes, and the probability of success respectively. Use the NEGBINOMDIST formula in cell B1 to calculate the probability based on these inputs.
Hints (2)
-
Make sure to reference the correct cells for failures, successes, and probability.
-
Remember that the first argument is the number of failures.
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 NEGBINOMDIST() formula:
Generate a NEGBINOMDIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NEGBINOMDIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NEGBINOMDIST() formula