BINOM.DIST.RANGE function

BINOM.DIST.RANGE(numberOfTrials, probability, numberOfSuccesses1, numberOfSuccesses2?) BINOM.DIST.RANGE(numberOfTrials; probability; numberOfSuccesses1; numberOfSuccesses2?)

numberOfTrials — Number or { Number }

The number of trials.

probability — Number or { Number }

The probability of success in each trial.

numberOfSuccesses1 — Number or { Number }

The number of successes in trials.

numberOfSuccesses2 — Number or { Number } (optional)

A number enabling this function to return the probability that the number of successful trials will be between the numberOfSuccesses1 parameter and the numberOfSuccesses2 parameter. If omitted, it is assumed to be equal to the numberOfSuccesses1 parameter.

Returns — Number or { Number }

A probability for a binomial distribution over an interval.

Returns the probability for a binomial distribution over an interval.

Example

BINOM.DIST.RANGE(70, 0.78, 50)BINOM.DIST.RANGE(70; 0,78; 50)

Returns roughly 0.05 (5%), the binomial distribution based on the probability of 50 successes in 70 trials and a 78% probability of success.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.