Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .