POISSON function
POISSON returns the probability of a number of rare events in a fixed window, like support tickets per hour. It is a compatibility function; POISSON.DIST replaces it in new workbooks.
Example
Read it as a sentence: find the chance of exactly 2 events when the average is 3, which gives 0.224041808.
A
B
C
D
1
0.224041808
2
3
Syntax
POISSON(x, mean, cumulative)
-
x(required) - Number of events.
-
mean(required) - Expected number of events.
-
cumulative(required) - TRUE for at-most x events, FALSE for exactly x.
Returns: A 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(2,3,FALSE) | 0.224041808 | Working example |
=POISSON(2,3,TRUE) | 0.423190081 | Other cumulative flag |
=POISSON(2,3,0) | 0.224041808 | Cumulative as 0 |
=POISSON("2",3,FALSE) | 0.224041808 | Text-number in first arg |
=POISSON({2,2},3,FALSE) | 0.224041808 | Array in first arg (lifts, spills) |
=POISSON(0,0,FALSE) | 1 | Mean 0 |
=POISSON("abc",3,FALSE) | #VALUE! | Non-numeric text in first arg |
=POISSON(NA(),3,FALSE) | #N/A | Error in first arg |
Watch out for
- Superseded by POISSON.DIST; use that in new workbooks.
- x is truncated to a whole number.
Where it works
- Excel
- POISSON is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .