# 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.