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

Sample Usage

CRITBINOM(100,0.005,0.8)

CRITBINOM(A2,A3,A4)

Syntax

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:

Error.

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.