# CRITBINOM

Formulas / CRITBINOM
The CRITBINOM function calculates the smallest number of successes required in a fixed number of binomial trials to meet or exceed a specified criterion value, making it useful for determining critical values in hypothesis testing.
`CRITBINOM(trials, probability_s, alpha)`
• trials - The number of Bernoulli trials.
• probability_s - The probability of success on each trial.
• alpha - The criterion value.

## Examples

• `=CRITBINOM(10, 0.5, 0.95)`

This formula calculates the smallest number of successes in 10 trials (n=10) such that the cumulative binomial distribution is greater than or equal to 0.95, assuming the probability of success on each trial is 0.5. The result is 8, meaning that at least 8 successes are needed to meet or exceed the criterion value of 0.95.

• `=CRITBINOM(20, 0.3, 0.8)`

This formula calculates the smallest number of successes in 20 trials (n=20) such that the cumulative binomial distribution is greater than or equal to 0.8, assuming the probability of success on each trial is 0.3. The result is 9, meaning that at least 9 successes are needed to meet or exceed the criterion value of 0.8.

## Summary

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

• The CRITBINOM function calculates the smallest number of successes required in a fixed number of binomial trials to meet or exceed a specified criterion value.
• The function is useful for determining critical values in hypothesis testing and statistical analysis involving binomial distributions.
• CRITBINOM requires three arguments: the number of trials, the probability of success on each trial, and the criterion value (alpha level).