Google Sheets POISSON Function: Syntax, Examples & Tips

x: The number of events for which you want to calculate the probability.

mean: The expected number of events (the average) that occur in a specified interval.

cumulative: A logical value that determines the form of the function. If TRUE, POISSON returns the cumulative distribution function; if FALSE, it returns the probability mass function.

What is a POISSON Function?

The POISSON function in Google Sheets is a statistical function used to calculate the probability of a given number of events occurring within a fixed interval of time or space, given a known average rate of occurrence. This function is particularly useful in scenarios where events happen independently and at a constant average rate.

In simpler terms, the POISSON function helps you determine the likelihood of a specific number of events happening in a defined period based on historical data.

A Practical Example

Imagine you are analyzing the number of customer arrivals at a store during a specific hour:

Customer Arrivals Data:

You want to calculate the probability of exactly 4 customers arriving during the 1st hour.

POISSON Formula

To achieve this, you would use the POISSON function as follows:

=POISSON(4, 5, FALSE)

In this formula:

• 4 is the number of events (customers arriving) for which you want to calculate the probability.
• 5 is the average number of events (average arrivals) in the given interval.
• FALSE indicates that you want the probability of exactly 4 arrivals (as opposed to cumulative probability).

Result of the Formula

When you apply the POISSON formula, it will return the probability of exactly 4 customers arriving during the 1st hour based on the average of 5 arrivals. The output might look like this:

This means there is approximately a 17.55% chance of exactly 4 customers arriving in the first hour.

Why Use POISSON?

The POISSON function is beneficial because it allows you to model and analyze events that occur randomly over a fixed period. It is widely used in fields such as operations management, telecommunications, and any area where understanding the frequency of events is crucial.

Key Takeaways:

• POISSON: A statistical function that calculates the probability of a given number of events occurring in a fixed interval.
• Independent Events: Assumes that events occur independently and at a constant average rate.
• Applications: Useful in various fields for modeling random events, such as customer arrivals, call center traffic, and more.
• Cumulative Probability: Can also be used to calculate cumulative probabilities by setting the third argument to TRUE.

The POISSON function is an essential tool for anyone working with statistical data in Google Sheets, providing a powerful way to analyze and interpret the likelihood of events.

Happy analyzing!