BINOM.DIST function
BINOM.DIST(SuccessCount, TrialCount, Probability,
IsCumulative) BINOM.DIST(SuccessCount; TrialCount; Probability;
IsCumulative)
SuccessCount
Number or { Number }
The number of successes in a set of trials.
TrialCount
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.