POISSON.DIST Function in Google Sheets: Complete Guide

Key Insights

• POISSON.DIST calculates the probability of a specific number of events occurring in a fixed interval, making it essential for analyzing rare, independent events like customer arrivals, system failures, or defect rates.
• The cumulative parameter switches between exact probability (FALSE) and “at most X” probability (TRUE)—understanding this distinction is critical for answering different business questions.
• Combining POISSON.DIST with SEQUENCE and ARRAYFORMULA lets you build complete probability distribution tables instantly, enabling visual analysis and better decision-making.

Introduction to the Poisson Distribution

The Poisson distribution models the probability of a given number of events occurring in a fixed interval of time or space. It’s specifically designed for rare, independent events where you know the average rate but want to understand the likelihood of specific outcomes.

Think about scenarios where this matters: How many customers will arrive at your store in the next hour? What’s the probability of zero server crashes this week? How likely is it that a manufacturing batch contains more than two defects?

These questions share common characteristics. The events are independent (one customer arriving doesn’t affect another), they occur at a known average rate, and you’re measuring over a fixed interval. When these conditions hold, Poisson distribution gives you precise probability calculations.

In Google Sheets, the POISSON.DIST function handles these calculations without requiring you to remember the underlying mathematical formula. This makes it accessible for operations managers, quality engineers, data analysts, and anyone who needs to make decisions based on event probabilities.

POISSON.DIST Syntax and Parameters

The function follows a straightforward syntax:

=POISSON.DIST(x, mean, cumulative)

x — The number of events you’re calculating the probability for. This must be a non-negative integer (0, 1, 2, 3, etc.). You’re asking: “What’s the probability of exactly this many events?”

mean — The expected average number of events in your interval. Also called lambda (λ) in statistics. This can be a decimal. If your call center averages 4.5 calls per hour, use 4.5.

cumulative — A boolean that changes what the function calculates:

• FALSE returns the probability of exactly x events (Probability Mass Function)
• TRUE returns the probability of x or fewer events (Cumulative Distribution Function)

Here’s a basic demonstration:

=POISSON.DIST(3, 5, FALSE)

This returns approximately 0.1404, meaning there’s a 14.04% chance of exactly 3 events occurring when the average is 5 events per interval.

Calculating Exact Probabilities (PMF)

When you need the probability of a precise number of events, use cumulative = FALSE. This gives you the Probability Mass Function (PMF) value.

Consider a help desk that receives an average of 8 tickets per hour. What’s the probability of receiving exactly 8 tickets in the next hour?

=POISSON.DIST(8, 8, FALSE)

Result: approximately 0.1396 or 13.96%

Notice something counterintuitive: even though 8 is the average, the probability of getting exactly 8 is only about 14%. This is because the distribution spreads probability across many possible outcomes.

What about receiving exactly 5 tickets?

=POISSON.DIST(5, 8, FALSE)

Result: approximately 0.0916 or 9.16%

And exactly 12 tickets?

=POISSON.DIST(12, 8, FALSE)

Result: approximately 0.0481 or 4.81%

The PMF is useful when you need to know the likelihood of specific scenarios. “What’s the chance we’ll have exactly zero defects?” or “How likely is it that precisely 10 customers arrive?”

Calculating Cumulative Probabilities (CDF)

More often, you’ll want to answer questions like “at most” or “at least” rather than “exactly.” This is where cumulative = TRUE becomes essential.

The cumulative function returns the probability of x or fewer events. Using our help desk example with an average of 8 tickets per hour:

=POISSON.DIST(5, 8, TRUE)

Result: approximately 0.1912 or 19.12%

This means there’s about a 19% chance of receiving 5 or fewer tickets in an hour.

To calculate “more than X” events, subtract the cumulative probability from 1:

=1 - POISSON.DIST(5, 8, TRUE)

Result: approximately 0.8088 or 80.88%

There’s an 81% chance of receiving more than 5 tickets per hour.

For “at least X” events (X or more), subtract the cumulative probability of (X-1) from 1:

=1 - POISSON.DIST(9, 8, TRUE)

This gives the probability of receiving 10 or more tickets (more than 9).

Here’s a quick reference for translating questions to formulas:

Real-World Applications with Worked Examples

Call Center Staffing

A call center receives an average of 12 calls per 15-minute interval during peak hours. Management wants to staff appropriately so they can handle the call volume 95% of the time.

First, find the number of calls that won’t be exceeded 95% of the time. You can test values:

=POISSON.DIST(16, 12, TRUE)

Result: 0.8987 (89.87% — not enough)

=POISSON.DIST(17, 12, TRUE)

Result: 0.9370 (93.70% — still not enough)

=POISSON.DIST(18, 12, TRUE)

Result: 0.9626 (96.26% — this works)

Staff for 18 calls per interval to meet the 95% threshold. You can also build a lookup table to find this systematically.

Quality Control

A manufacturing process produces an average of 2.5 defects per 1000 units. What’s the probability that a batch of 1000 units has zero defects?

=POISSON.DIST(0, 2.5, FALSE)

Result: 0.0821 or 8.21%

What’s the probability of having 3 or fewer defects (acceptable quality)?

=POISSON.DIST(3, 2.5, TRUE)

Result: 0.7576 or 75.76%

What’s the probability of having more than 5 defects (triggering a review)?

=1 - POISSON.DIST(5, 2.5, TRUE)

Result: 0.0420 or 4.20%

Website Error Monitoring

Your application logs an average of 3 errors per day. What’s the probability of a “quiet day” with 1 or fewer errors?

=POISSON.DIST(1, 3, TRUE)

Result: 0.1991 or 19.91%

What’s the probability of a “bad day” with 6 or more errors?

=1 - POISSON.DIST(5, 3, TRUE)

Result: 0.0839 or 8.39%

Building a Poisson Distribution Table and Chart

Creating a complete probability distribution helps visualize the spread of possible outcomes. Use SEQUENCE with ARRAYFORMULA for efficiency.

Assume your mean is in cell B1 (let’s say it’s 5). In cell A3, enter:

=SEQUENCE(16, 1, 0)

This creates values 0 through 15 in column A. In cell B3, enter:

=ARRAYFORMULA(POISSON.DIST(A3:A18, $B$1, FALSE))

This calculates the probability for each value of x simultaneously.

For a single-formula approach that generates both columns:

=ARRAYFORMULA({SEQUENCE(16,1,0), POISSON.DIST(SEQUENCE(16,1,0), B1, FALSE)})

To add cumulative probabilities as a third column:

=ARRAYFORMULA({SEQUENCE(16,1,0), POISSON.DIST(SEQUENCE(16,1,0), B1, FALSE), POISSON.DIST(SEQUENCE(16,1,0), B1, TRUE)})

Select your data and insert a column chart to visualize the distribution. You’ll see the characteristic right-skewed shape of the Poisson distribution, with the peak near the mean and a long tail toward higher values.

Common Errors and Troubleshooting

#NUM! Error

This occurs when you provide invalid numeric inputs:

=POISSON.DIST(-1, 5, FALSE)   // Error: x cannot be negative
=POISSON.DIST(3, -2, FALSE)   // Error: mean cannot be negative

The solution is to validate your inputs. Use MAX or ABS functions if your data might contain negative values:

=POISSON.DIST(MAX(0, A1), B1, FALSE)

#VALUE! Error

This happens with non-numeric inputs:

=POISSON.DIST("three", 5, FALSE)   // Error: text instead of number

Check that your cell references contain actual numbers, not text formatted as numbers. Use VALUE() to convert if needed.

When Poisson Doesn’t Apply

The Poisson distribution assumes events are independent and occur at a constant average rate. It breaks down when:

• Events cluster (website traffic during a viral post)
• Events aren’t independent (one failure causes another)
• The interval changes (comparing hourly and daily rates without adjustment)
• The probability of an event is high (use binomial instead)

Legacy POISSON Function

Google Sheets also supports POISSON() without the “.DIST” suffix. This is a legacy function maintained for compatibility. Use POISSON.DIST for new work—it’s the modern standard and matches Excel’s naming conventions.

=POISSON(3, 5, FALSE)      // Legacy
=POISSON.DIST(3, 5, FALSE) // Preferred

Both return identical results, but POISSON.DIST is the recommended approach for clarity and future compatibility.

The Poisson distribution is a practical tool for anyone dealing with count-based data and event probabilities. Master POISSON.DIST, and you’ll make better staffing decisions, set realistic quality thresholds, and understand the natural variation in your metrics.