NEGBINOMDIST
The NEGBINOMDIST function in Google Sheets is a statistical tool that calculates the probability of drawing a certain number of failures before a certain number of successes, given a probability of success in independent trials.
Function Syntax and Parameters
Syntax: NEGBINOMDIST(num_failures, num_successes, prob_success)
Parameters:
num_failures: The number of failures.num_successes: The number of successes.prob_success: The probability of success in each independent trial.
Step-by-Step Tutorial
- Calculating the probability of drawing a certain number of failures before a certain number of successes:
- Example:
=NEGBINOMDIST(3, 5, 0.2) - Result: Returns the probability of drawing 3 failures before achieving 5 successes with a success probability of 0.2.
- Example:
Use Cases and Scenarios
- Quality Control: Determine the probability of encountering a certain number of defective products before reaching a certain number of non-defective products.
- Game Probabilities: Calculate the likelihood of rolling a certain number of losing outcomes before a specific number of winning outcomes in games of chance.
- Business Forecasting: Estimate the probability of experiencing a certain number of unsuccessful attempts before achieving a desired number of successful outcomes.
Related Functions
None
Related Articles
None