O'Reilly logo

The Complete Idiot's Guide to Statistics, 2nd Edition by Robert Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

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

Start Free Trial

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.
279
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.

Start Free Trial

No credit card required