Excel functions / Statistics

POISSON.DIST function

The chance of a number of events in a period, given how many happen on average.

Syntax

=POISSON.DIST(x, mean, cumulative)

Arguments

When to use it

POISSON.DIST gives the chance of a number of events in a fixed time or space when they happen independently at a known average rate: calls in an hour, arrivals at a counter, faults on a cable. With FALSE it is exactly that many; with TRUE, that many or fewer.

Examples

  1. Exactly 3 calls in an hour that averages 5

    ABCD
    1CallsAverage
    23514.0%

    In D2: =POISSON.DIST(A2, B2, FALSE) → 14.0%

    Try this example

  2. More than 8 calls in that hour

    ABCD
    1CallsAverage
    2856.8%

    In D2: =1-POISSON.DIST(A2, B2, TRUE) → 6.8%

    Try this example

Common mistakes

POISSON.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 POISSON.

Try POISSON.DIST in the playground

Related functions