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

Want to practice POISSON.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=POISSON.DIST(x, mean, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe number of events (decimals are truncated).
meanYesThe average number of events per period.
cumulativeYesTRUE 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.

B2fx=POISSON.DIST(A2,3,FALSE)
ABC
1ComplaintsExactlyAt most
200.04980.0498
310.14940.1991
420.22400.4232
530.22400.6472
640.16800.8153
750.10080.9161
860.05040.9665
=POISSON.DIST(A2,3,FALSE) Explain

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:

=1-POISSON.DIST(5,3,TRUE) Explain

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.
Kyle Stott

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.