The Excel POISSON.DIST Function

Poisson Distribution

The Poisson distribution is a discrete probability function that is used to calculate the probability of a number of events occurring in a specified time period.

The Poisson probability mass function calculates the probability that there will be exactly x occurrences and is given by the formula:

Poisson Probability Mass Function

where λ is the expected number of occurrences within the specified time period.

The cumulative Poisson distribution function calculates the probability that there will be at most x occurrences and is given by the formula:

Cumulative Poisson Probability Function
Further information on the Poisson Distribution is provided on the Wikipedia Poisson Distribution Page

Basic Description

The Excel POISSON.DIST function calculates the Poisson Probability Mass Function or the Cumulative Poisson Probability Function for a supplied set of parameters.

The function is new to Excel 2010 and so is not available in earlier versions of Excel. However the Poisson.Dist function is simply an updated version of the Poisson function, which is available in earlier versions of Excel.

The syntax of the Poisson.Dist function is:

POISSON.DIST( x, mean, cumulative )

Where the function arguments are:

x-

The number of events that you want the probability for (must be ≥ 0).

This value should be an integer; If a decimal is supplied, it will be truncated to an integer by Excel.
mean-The expected number of events (must be ≥ 0).
cumulative-

A logical argument that specifies the type of distribution to be calculated.

This can be either:

TRUE-The cumulative distribution function
FALSE-The probability mass function

Poisson.Dist Function Examples

Example 1 - Poisson Probability Mass Function

Plot of Poisson Probability Mass Function with Lambda=25
Poisson Probability Mass Function with mean (λ) = 25

The above chart on the right shows the Poisson Probability Mass Function with an expected value (mean) equal to 25.

If you want to calculate the value of this function at x = 40, this can be done using the Excel Poisson.Dist function, as follows:

=POISSON.DIST( 20, 25, FALSE )

This gives the result 0.051917469.


Example 2 - Cumulative Poisson Probability Function

Plot of Cumulative Poisson Probability Function with Lambda=40
Cumulative Poisson Probability Function with mean (λ) = 40

The above chart on the right shows the Cumulative Poisson Probability Function with an expected value (mean) equal to 40.

If you want to calculate the value of this function at x = 25, this can be done using the Excel Poisson.Dist function, as follows:

=POISSON.DIST( 35, 40, TRUE )

This gives the result 0.242414198.


Further information and examples of the Excel Poisson.Dist function are provided on the Microsoft Office website.


Poisson.Dist Function Errors

If you get an error from the Excel Poisson.Dist function this is likely to be one of the following:

Common Errors
#NUM!-Occurs if either the supplied value of x, or the supplied mean is < 0.
#VALUE!-Occurs if any of the supplied arguments are non-numeric.