POISSON.DIST Function
Returns the Poisson probability of a number of events in a period.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
POISSON.DIST gives the chance of a number of events in a fixed period when events happen independently at a known average rate: complaints per day, website orders per hour, typos per page.
With cumulative FALSE it's exactly x events; with TRUE, at most x.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The number of events (decimals are truncated). |
| mean | Yes | The average number of events per period. |
| cumulative | Yes | TRUE for the chance of at most this many; FALSE for exactly this many. |
Examples
Example 1 — Customer complaints per day
Northstar receives 3 complaints a day on average. Column B is filled down from B2.
| A | B | C | |
|---|---|---|---|
| 1 | Complaints | Exactly | At most |
| 2 | 0 | 0.0498 | 0.0498 |
| 3 | 1 | 0.1494 | 0.1991 |
| 4 | 2 | 0.2240 | 0.4232 |
| 5 | 3 | 0.2240 | 0.6472 |
| 6 | 4 | 0.1680 | 0.8153 |
| 7 | 5 | 0.1008 | 0.9161 |
| 8 | 6 | 0.0504 | 0.9665 |
A complaint-free day happens about 5% of the time; 5 or fewer covers about 92% of days.
Example 2 — A busy day
More than 5 complaints:
Returns about 0.084 — roughly one day in twelve.
Common mistakes
- #NUM! x or mean is negative.
- Match the period. If the average is per day, x must be per day too. For a week, use a mean of 21.
Notes
- POISSON.DIST replaces the older POISSON function.
- Related functions: EXPON.DIST (time between events), BINOM.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.