Investment Studio > Expressions > Functions > Statistical > CRITBINOM

float critbinom(integer trials, float success_probability, float criterion)

Returns the smallest number of successes for which the binomial CDF (Cumulative Distribution Function) is >= the criterion.

The number of successes >= 0 is the number of successful outcomes of a series of independent trials, where each trial can only result in success or failure (so-called Bernoulli trials).

trials >= successes is the total number of trials.

success_probability Î [0, 1] is the probability of success in a single trial.

criterion Î [0, 1] is the cumulative probability to be exceeded.

Example

If you flip an evenly balanced coin 10 times, there's >= 10% chance of getting

=critbinom(10, 50%, 10%)

= 3 or fewer heads (i.e. 3, 2, 1, or 0). There's >= 30% chance of getting

=critbinom(10, 50%, 30%)

= 4 or fewer heads.

See also binomdist, combin, fact, hypgeomdist, negbinomdist, permut, prob.