With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

Using Excel to Calculate Poisson Probabilities

You can also conveniently calculate Poisson probabilities using Excel. The built-in POISSON function has the following characteristics:
POISSON(x, m, cumulative)
where:
cumulative = FALSE if you want the probability of exactly x occurrences
cumulative = TRUE if you want the probability of x or fewer occurrences
For instance, Figure 10.2 shows the POISSON function being used to calculate the probability that there will be exactly two accidents in the intersection next month.
Figure 10.2
POISSON function in Excel for exactly x occurrences.
Cell A1 contains the Excel formula =POISSON(2,1.8,FALSE) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required