# CRITBINOM

## Definition

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.

`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:

A
B
C
D
1
14
0.75
0.85
12

JavaScript errors detected