BINOM.DIST

Calculates the probability of a specific number of successes in a given number of independent trials.

Syntax:

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

number_s is required, and is the number of successes.

trials is required, and is the total number of trials.

probability_s is required, and is the probability of success on each individual trial.

cumulative is required, and is a logical value:

TRUE: Returns the cumulative probability of getting at most number_s successes.

FALSE: Returns the probability of getting exactly number_s successes.

Example:

If number_s contains 3, trials contains 10, probability_s contains 0.5 and cumulative contains FALSE:

BINOM.DIST(3, 10, 0.5, FALSE)

returns 0.1171875

This example finds the probability of getting exactly 3 heads, when you flip a coin 10 times.