Syntax
=POISSON(x, mean, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The number of events |
mean | Required | The expected number of events |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use POISSON
POISSON is kept so older workbooks keep working. It calculates the same way as POISSON.DIST, which is the name to use in new formulas.
POISSON takes 3 required arguments. Type =POISSON( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=POISSON(2, 5, TRUE)Result Related compatibility functions
- NORMSDISTReturns the cumulative standard normal distribution (older form of NORM.S.DIST).
- NORMSINVReturns the inverse of the standard normal distribution (older name of NORM.S.INV).
- PERCENTILEReturns the k-th percentile of the values (older name of PERCENTILE.INC).
- PERCENTRANKReturns the percentage rank of a value in a data set (older name of PERCENTRANK.INC).
- QUARTILEReturns a quartile of the values (older name of QUARTILE.INC).
- RANKReturns the rank of a number in a list (older name of RANK.EQ).
- STDEVEstimates the standard deviation from a sample (older name of STDEV.S).
- STDEVPReturns the population standard deviation (older name of STDEV.P).
- TDISTReturns the one or two tailed Student's t distribution (older form of T.DIST.RT and T.DIST.2T).