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

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.