POISSON.DIST function
POISSON.DIST returns the probability of a given number of random events in a fixed interval, like support tickets per hour or defects per batch. It can give a single probability or a cumulative one.
Example
Read it as a sentence: find the exact chance of 2 events when the average is 5, which gives 0.0842243374885683.
A
B
C
D
1
0.0842243374885683
2
3
Syntax
POISSON.DIST(x, mean, cumulative)
-
x(required) - Number of events.
-
mean(required) - Expected number of events.
-
cumulative(required) - TRUE for x or fewer events, FALSE for exactly x.
Returns: The Poisson probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=POISSON.DIST(2,3,FALSE) | 0.224041808 | Working example |
=POISSON.DIST(2,3,TRUE) | 0.423190081 | Other cumulative flag |
=POISSON.DIST(2,3,0) | 0.224041808 | Cumulative as 0 |
=POISSON.DIST("2",3,FALSE) | 0.224041808 | Text-number in first arg |
=POISSON.DIST({2,2},3,FALSE) | 0.224041808 | Array in first arg (lifts, spills) |
=POISSON.DIST(0,0,FALSE) | 1 | Mean 0 |
=POISSON.DIST("abc",3,FALSE) | #VALUE! | Non-numeric text in first arg |
=POISSON.DIST(NA(),3,FALSE) | #N/A | Error in first arg |
Watch out for
- x is truncated to a whole number.
- Assumes events are independent and the rate is constant.
Where it works
- Excel
- POISSON.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Sheets has POISSON and POISSON.DIST.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .