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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.