Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.Poisson_Dist Method (Excel)

Published: July 16, 2012

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 Added: Excel 2010

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.

Return Value

Double

  • 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: POISSON_DIST_FALSE_ZA10390998For cumulative = TRUE: POISSON_DIST_TRUE_ZA10390999

Community Additions

ADD
Show:
© 2014 Microsoft