BINOM.DIST function

BINOM.DIST(numberOfSuccesses, numberOfTrials, probability, isCumulative) BINOM.DIST(numberOfSuccesses; numberOfTrials; probability; isCumulative)

numberOfSuccesses — Number or { Number }

The number of successes in a set of trials.

numberOfTrials — Number or { Number }

The number of trials.

probability — Number or { Number }

The probability of success in each trial.

isCumulative — Logical or { Logical }

FALSE to calculate the probability mass function and TRUE to calculate the cumulative probability function.

Returns — Number or { Number }

A probability for a binomial distribution.

Returns a probability for a binomial distribution.

Examples

BINOM.DIST(3, 12, 0.5, FALSE)BINOM.DIST(3; 12; 0,5; FALSE)

Returns roughly 0.05 (5%), the probability that heads will come up exactly 3 times in 12 flips of a coin.

BINOM.DIST(3, 12, 0.5, TRUE)BINOM.DIST(3; 12; 0,5; TRUE)

Returns roughly 0.07 (7%), the probability that heads will come up 0, 1, 2 or 3 times in 12 flips of a coin.

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