ExcelFlux

POISSON function

the Poisson distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

At an average of three incidents, find the probability that the count does not exceed the stated number.

A worked example from the workbook

RowA
6Input
70
82
96
Record 1
=POISSON(A7,3,TRUE)

Illustrative output0.04978706837

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

At an average of three incidents, find the probability that the count does not exceed the stated number.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0
8 2
9 6
Trial Expression Sample output
Record 1 =POISSON(A7,3,TRUE) 0.04978706837
Record 2 =POISSON(A8,3,TRUE) 0.4231900811
Record 3 =POISSON(A9,3,TRUE) 0.9664914647
Microsoft Excel reference