CRITBINOM

Definition: CRITBINOM is a function that returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

Syntax: =CRITBINOM(trials, probability_s, alpha)

Situation: This formula is suitable when you need to find the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value, such as finding the number of successes required to meet a specified probability.

Example: If you have 10 trials with a success probability of 0.3 and a criterion value of 0.05, the smallest number of successes required can be found using the formula =CRITBINOM(10, 0.3, 0.05), which returns a value of 1.