SheetFX
≡
<< Go back to all functions

CRITBINOM

The CRITBINOM function in Google Sheets calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

Function Syntax and Parameters

Syntax: CRITBINOM(num_trials, prob_success, target_prob)

Parameters:

  • num_trials: The number of trials in the binomial distribution.
  • prob_success: The probability of success in each trial.
  • target_prob: The desired cumulative probability for which the function should find the smallest value.

Step-by-Step Tutorial

  1. Using CRITBINOM to calculate the smallest value:
    • Example: =CRITBINOM(10, 0.5, 0.8)
    • Result: The function will find the smallest value for which the cumulative binomial distribution is greater than or equal to 0.8.

Use Cases and Scenarios

  1. Quality Assurance: Determine the minimum number of defective items in a sample to meet a desired quality level.
  2. Risk Analysis: Calculate the minimum number of successful outcomes to achieve a certain level of risk.

Related Functions

None.

Related Articles

None.