BINOM.INV

The BINOM.INV function in Google Sheets returns the smallest value for which the cumulative binomial distribution is greater than or equal to a specified target probability. It's the modern equivalent of the legacy CRITBINOM function and is commonly used in quality control and risk analysis. Dive into our comprehensive guide to learn how it works.

Parameters

• num_trials: The number of independent trials.
• prob_success: The probability of success in each trial.
• target_prob: The target probability for which you want to find the smallest cumulative value.

Step-by-Step Tutorial

1. Finding a critical value:
   • Example: =BINOM.INV(10, 0.5, 0.75)
   • Result: 6 (the smallest number of successes for which the cumulative binomial probability is at least 0.75)

Use Cases and Scenarios

1. Quality Control: Determine the acceptable number of defective units in a batch given a target confidence level.
2. Risk Analysis: Estimate thresholds for pass/fail outcomes in repeated trials.
3. Statistical Planning: Set sample-size or approval thresholds based on desired probability targets.

Related Functions

• CRITBINOM: The legacy version of BINOM.INV with identical behavior.
• BINOM.DIST: Returns the individual term binomial distribution probability.

Related Articles

• Understanding Statistical Functions in Google Sheets