Excel functions / Statistics

BINOM.DIST function

The chance of a number of successes in a set number of tries, each with the same chance.

Syntax

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

Arguments

When to use it

BINOM.DIST gives the chance of a number of successes in a set of tries, when each try has the same chance of success: heads in coin tosses, defective items in a batch, people who say yes. With FALSE it is the chance of exactly that many; with TRUE, that many or fewer.

Examples

  1. Exactly 6 heads in 10 tosses

    ABCD
    1HeadsTosses
    261020.5%

    In D2: =BINOM.DIST(A2, B2, 0.5, FALSE) → 20.5%

    Try this example

  2. At most 2 faulty items in 50, when 2% are faulty

    ABCD
    1FaultyBatch
    225092.2%

    In D2: =BINOM.DIST(A2, B2, 2%, TRUE) → 92.2%

    Try this example

Common mistakes

BINOM.DIST in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as BINOMDIST.

Try BINOM.DIST in the playground

Related functions