ID EN
…
#Statistical

BINOMDIST

Excel Functions

Get binomial distribution probability

Syntax

EXCEL 
=BINOMDIST(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 BINOMDIST function returns the individual term binomial distribution probability. You can use BINOMDIST to calculate probabilities that an event will occur a certain number of times in a given number of trials. BINOMDIST 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. Note: the BINOMDIST function is classified as a compatibility function, replaced by the BINOM.DIST function. In the example shown, the BINOMDIST 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 h

Examples

Example

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

EXCEL 
=BINOMDIST(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 BINOMDIST to calculate the probability that there are

EXCEL 
=BINOMDIST(B5,10,0.1667,TRUE) // returns 0.1614

See Also

BINOM.DIST