Home Â» How to Use the Poisson Distribution in Excel

# How to Use the Poisson Distribution in Excel

TheÂ Poisson distribution is one of the most commonly used distributions in statistics.

In Excel, we can use the POISSON.DIST() function to find the probability that an event occurs a certain number of times during a given interval, based on knowing the mean number of times the event occurs during the given interval.

The syntax forÂ POISSON.DISTÂ is as follows:

POISSON.DIST(x, mean, cumulative)

• x:Â number of occurrences during a given interval
• mean:Â mean number of occurrences during a given interval
• cumulative: TRUE returns the cumulative probability; FALSE returns the exact probability

The following examples illustrate how to solve Poisson probability questions using POISSON.DIST.

### Example 1

AÂ hardware store sells 3 hammers per day on average. What is the probability that they will sell 5 hammers on a given day?

In this example, we can plug in the following numbers to the POISSON.DIST function:

• x:Â number of occurrences during a given interval (sellingÂ 5Â hammers)
• mean:Â mean number of occurrences during a given interval (they sellÂ 3Â on average)
• cumulative: FALSE (we want an exact probability, not a cumulative probability)

To answer this question, we can use the following formula in Excel:Â POISSON.DIST(5, 3, FALSE)

The probability that the store sells 5 hammers in a given day isÂ 0.100819.

### Example 2

A certain store sells 15 cans of tuna per day on average. What is the probability that this store sells more than 20 cans of tuna in a given day?

In this example, we can plug in the following numbers to the POISSON.DIST function:

• x:Â number of occurrences during a given interval (sellingÂ 20Â cans)
• mean:Â mean number of occurrences during a given interval (they sellÂ 15Â cansÂ on average)
• cumulative: TRUEÂ (we want a cumulative probability, not an exact probability)

To answer this question, we can use the following formula in Excel: 1 â€“Â POISSON.DIST(20, 15, TRUE)

The probability that the store sells more than 20 cans of tuna in a given day isÂ 0.082971.

Note:Â In this example, POISSON.DIST(20, 15, TRUE) returns the probability that the store sells 20 or fewer cans of tuna. So, to find the probability that the store sells more than 20 cans, we simply use 1 â€“ POISSON.DIST(20, 15, TRUE).

### Example 3

A certain sporting goods store sells seven basketballs per day on average. What is the probability that this store sells four or less basketballs in a given day?

In this example, we can plug in the following numbers to the POISSON.DIST function:

• x:Â number of occurrences during a given interval (sellingÂ 4Â basketballs)
• mean:Â mean number of occurrences during a given interval (they sellÂ 7Â on average)
• cumulative: TRUEÂ (we want a cumulative probability, not an exact probability)

To answer this question, we can use the following formula in Excel:Â POISSON.DIST(4, 7, TRUE)

The probability that the store sells 4 or fewer basketballs in a given day isÂ 0.172992.

### Example 4

A certain store sells twelve pineapples per day on average. What is the probability that this store sells between 12 and 14 pineapples in a given day?

In this example, we can plug in the following numbers to the POISSON.DIST function:

• x:Â number of occurrences during a given interval (sellingÂ between 12 and 14Â pineapples)
• mean:Â mean number of occurrences during a given interval (they sellÂ 12Â on average)
• cumulative: TRUEÂ (we want a cumulative probability, not an exact probability)

To answer this question, we can use the following formula in Excel:

POISSON.DIST(14, 12, TRUE) â€“Â POISSON.DIST(11, 12, TRUE)

The probability that the store sells between 12 and 14 pineapples in a given day isÂ 0.310427.

Note:Â In this example, POISSON.DIST(14, 12, TRUE) returns the probability that the store sells 14 or fewer pineapples and POISSON.DIST(11, 12, TRUE) returns the probability that the store sells 11 or fewer pineapples . So, to find the probability that the store sells between 12 and 14 titles, we subtract the difference so that we are actually finding the probability that the store sells either 12, 13, or 14 pineapples.

An alternative way to solve this problem is to simply find the individual probabilities of selling 12, 13, and 14 pineapples, and then add up these probabilities:

This gives us the same probability as the previous method.