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
x: How many events.mean: How many are expected on average.cumulative: TRUE for that many or fewer; FALSE for exactly that many.
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
Exactly 3 calls in an hour that averages 5
A B C D 1 Calls Average 2 3 5 14.0% In D2:
=POISSON.DIST(A2, B2, FALSE)→ 14.0%More than 8 calls in that hour
A B C D 1 Calls Average 2 8 5 6.8% In D2:
=1-POISSON.DIST(A2, B2, TRUE)→ 6.8%
Common mistakes
- A rate for a different period. The average must be for the same length of time as the count: 5 an hour means 2.5 in half an hour.
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.
- Czech: POISSON.DIST
- Danish: POISSON.FORDELING
- Dutch: POISSON.VERD
- Finnish: POISSON.JAKAUMA
- French: LOI.POISSON.N
- German: POISSON.VERT
- Hungarian: POISSON.ELOSZLÁS
- Italian: DISTRIB.POISSON
- Norwegian: POISSON.FORDELING
- Polish: ROZKŁ.POISSON
- Portuguese (Brazil): DIST.POISSON
- Portuguese (Portugal): DIST.POISSON
- Russian: ПУАССОН.РАСП
- Spanish: POISSON.DIST
- Swedish: POISSON.FÖRD
- Turkish: POISSON.DAĞ
Also written as POISSON.
Try POISSON.DIST in the playground
Related functions
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.
- EXPON.DIST: The exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
- NORM.DIST: The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.