Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

POISSONDIST

Returns the value of the Poisson distribution function or the Poisson cumulative distribution function for a specified number and mean.

Sample Usage

POISSONDIST(2.4,1,TRUE)
POISSONDIST(A2,A3,FALSE)

Syntax

POISSONDIST(number, mean, [cumulative])

  • number - The input to the distribution function.
  • mean - The mean value of the Poisson distribution.
  • cumulative - [OPTIONAL] A logical value that determines the form of the probability distribution to be returned.

Examples

POISSONDIST(2.4,1,TRUE) returns a value of 0.9196, the cumulative poisson probability with the arguments specified.

 

Notes

  • Set cumulative to TRUE to use the cumulative distribution function, and set it to FALSE to use the probability mass function.