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).

Frequently Asked Questions

What does the CRITBINOM function do?
The CRITBINOM function calculates the smallest number of successes needed in a fixed number of trials for the cumulative binomial distribution to meet or exceed a specified criterion value. It is used to find the critical value in a binomial distribution.
What are the required arguments for the CRITBINOM function?
The CRITBINOM function requires three arguments: the number of trials (n), the probability of success on each trial (p), and the criterion value (alpha). The function returns the smallest number of successes needed to meet or exceed the criterion value.
What error does CRITBINOM return if the arguments are invalid?
CRITBINOM returns a #NUM! error if the number of trials (n) is not an integer greater than 0, if the probability of success (p) is not between 0 and 1 (inclusive), or if the criterion value (alpha) is not between 0 and 1 (inclusive).
Can CRITBINOM be used to calculate the critical value for a one-tailed test?
Yes, CRITBINOM can be used to calculate the critical value for a one-tailed test in a binomial distribution. The criterion value (alpha) represents the significance level for the one-tailed test.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV