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.
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:
A
|
B
|
C
|
D
|
|
|---|---|---|---|---|
1
|