O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

POISSON.DIST()/POISSON()

Syntax. POISSON.DIST(x,mean,cumulative)

Definition. This function returns the probabilities of a Poisson distributed random variable. A common application of the Poisson distribution is the prediction of the number of events over a specific time period such as the number of calls a call center receives within an hour.

Arguments

  • x (required). The number of events.

  • mean (required). The expected numeric value.

  • cumulative (required). The logical value that represents the type of the function. If cumulative is TRUE, POISSON.DIST() returns the cumulative Poisson probability that the number of random events occurring will be between zero and x inclusive. If cumulative is FALSE, the function returns the probability that the number ...

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