Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.

Sample Usage




CRITBINOM(num_trials, prob_success, target_prob)

  • num_trials - The number of independent trials.

  • prob_success - The probability of success in any given trial.

  • target_prob - The desired threshold probability.

See Also

PROB: Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.

BINOMDIST: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

In order to use the CRITBINOM formula, begin typing the formula in the area you would like to display the outcome: 






User does not have sufficient privileges to access this Content
Learn More