ID EN
…
#Statistical

BINOM.DIST

Excel Functions

Get binomial distribution probability

Syntax

EXCEL 
=BINOM.DIST(number_s, trials, probability_s, cumulative)

Arguments

Parameter Description
number_s The number of successes.
trials The number of independent trials.
probability_s The probability of success on each trial.
cumulative TRUE = cumulative distribution function, FALSE=probability mass function.

Return Value

Calculated probability

Details

The BINOM.DIST function returns the individual term binomial distribution probability. You can use BINOM.DIST to calculate probabilities that an event will occur a certain number of times in a given number of trials. BINOM.DIST returns probability as a decimal number between 0 and 1. Binary data occurs when an observation can be placed into only two categories. For example, when tossing a coin, the result can only be heads or tails. Or, when rolling a die, the result can either be 6 or not 6. In the example shown, the BINOM.DIST function is used to calculate the probability of rolling a 6 with a die. Since a die has six sides, the probability of rolling a 6 is 1/6, or 0.1667. Column B holds the number of trials, and the formula in C5, copied down, is: which returns the probability of rolli

Examples

Example

In the example shown, the BINOM.DIST function is used to calculate the probability of rolling a 6 with a die. Since a die has six sides, the probabili

EXCEL 
=BINOM.DIST(B5,10,0.1667,TRUE) // returns 0.1614
Example

The formula in D5 is the same, except the cumulative argument has been set to TRUE. This causes BINOM.DIST to calculate the probability that there are

EXCEL 
=BINOM.DIST(B5,10,0.1667,TRUE) // returns 0.1614

See Also

BINOM.DIST