Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining

# WorksheetFunction.Poisson_Dist Method (Excel)

Office 2013

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in one minute.

## Version Information

Version Added: Excel 2010

## Syntax

expression .Poisson_Dist(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

### Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

X - The number of events.

Arg2

Required

Double

Mean - The expected numeric value.

Arg3

Required

Boolean

Cumulative - A logical value that determines the form of the probability distribution returned. If cumulative is TRUE, POISSON_DIST returns the cumulative Poisson probability that the number of random events occurring will be between 0 (zero) and x inclusive; if FALSE, it returns the Poisson probability mass function that the number of events occurring will be exactly x.

Double

## Remarks

• If x is not an integer, it is truncated.

• If x or mean is nonnumeric, POISSON_DIST returns the #VALUE! error value.

• If x < 0, POISSON_DIST returns the #NUM! error value.

• If mean ≤ 0, POISSON_DIST returns the #NUM! error value.

• POISSON_DIST is calculated as follows. For cumulative = FALSE: For cumulative = TRUE:

Show:
© 2015 Microsoft