POISSON.DIST function

The POISSON.DIST function in Excel calculates the Poisson distribution for a given number of events. The Poisson distribution is often used to model the number of events occurring within a fixed interval of time or space, when these events happen at a constant average rate and independently of each other.

Syntax:

POISSON.DIST(x, mean, cumulative)

Arguments:

• x: Required. The number of events for which you want to calculate the Poisson distribution probability.
• mean: Required. The expected number of events (mean or average) within the given interval. This is often denoted as λ (lambda) in Poisson distribution formulas.
• cumulative: Required. A logical value that determines the form of the function:
  • If TRUE, the function returns the cumulative distribution function (CDF), which is the probability that there are fewer than or equal to x events.
  • If FALSE, the function returns the probability mass function (PMF), which is the probability that exactly x events occur.

Output:

The function returns the probability associated with the Poisson distribution for the given number of events and mean.

Formula:

The Poisson probability mass function (PMF) is:

$$P(X = x) = \frac{\lambda^x e^{-\lambda}}{x!}$$

Where:

• λ (mean) is the expected number of events in the given time or space interval.
• x is the number of events for which you want to calculate the probability.
• e is Euler’s number (approximately 2.71828).

Example 1: Calculating the Probability of Exactly x Events

Suppose you want to find the probability of 3 events occurring, and the mean number of events is 2.

To calculate the probability of exactly 3 events occurring:

=POISSON.DIST(3, 2, FALSE)

This will return the probability mass function (PMF) for 3 events, with an expected mean of 2 events.

Example 2: Calculating the Cumulative Probability (Up to x Events)

Suppose you want to calculate the cumulative probability of 3 or fewer events occurring, with a mean of 2 events.

Use the formula:

=POISSON.DIST(3, 2, TRUE)

This will return the cumulative probability that the number of events is less than or equal to 3, assuming an average of 2 events.

Key Points:

• The POISSON.DIST function can return both the probability mass function (PMF) or the cumulative distribution function (CDF) based on the cumulative argument.
• The function is particularly useful for situations where events happen at a constant average rate over a fixed interval (e.g., the number of customers arriving at a store per hour or the number of phone calls received by a call center).
• The mean represents the average or expected number of events during the interval.

Use Cases:

• Business: Calculate the probability of a certain number of customer arrivals, sales, or defects in a production process over a set time period.
• Healthcare: Model the number of occurrences of a particular disease or condition in a given population over a specified period.
• Traffic Management: Estimate the number of accidents or breakdowns on a highway during a specific time frame.

Notes:

• POISSON.DIST assumes that events are independent and occur at a constant rate.
• The function is most useful when you are modeling rare events over time or space, such as accidents, arrivals, or failures.
• If you are using a more general version of the Poisson distribution (for example, a distribution with a different mean), POISSON.DIST is appropriate to use. If your data or events involve a continuous distribution, consider other statistical functions like NORM.DIST.