POISSON (PQL - xl)
This function returns the Poisson distribution
- Library: PQL \ Spreadsheet \ Compatibility
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
POISSON(x, mean, cumulative)
Function Arguments
Name | Description | Type | Optional |
x | Number of events Provide an integer, or the value is truncated. The number must be greater than zero | Number |
|
mean | Expected numeric value The number must be greater than zero | Number |
|
cumulative | Set to TRUE to return the cumulative Poisson probability that the number of random events occurring is between zero and nevents inclusive. Set to FALSE to return the Poisson probability mass function that the number of events occurring is exactly nevents | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'POISSON' function - using the same inputs, logic and outputs.