POISSON.DIST function
Summary
Returns the Poisson distribution
Syntax
POISSON.DIST(x,mean,cumulative)
The POISSON.DIST function syntax has the following arguments:
• X Required. The number of events.
• Mean Required. The expected numeric value.
• Cumulative Required. A logical value that determines the form of the probability distribution returned. 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 FALSE, it returns the Poisson probability mass function that the number of events occurring will be exactly x.
• X Required. The number of events.
• Mean Required. The expected numeric value.
• Cumulative Required. A logical value that determines the form of the probability distribution returned. 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 FALSE, it returns the Poisson probability mass function that the number of events occurring will be exactly x.
Example
=POISSON.DIST(A2,A3,TRUE)
=POISSON.DIST(A2,A3,FALSE)
=POISSON.DIST(A2,A3,FALSE)