Formualizer Docs
ReferenceFunctionsStatistics Functions

POISSON.DIST

POISSON.DIST: Returns the Poisson probability for event count `x` at average rate `mean`.

Summary

POISSON.DIST supports exact-count mode (PMF) and cumulative mode (CDF).

Remarks

  • x is truncated to an integer and must be at least 0.
  • mean must be non-negative.
  • Set cumulative to non-zero for CDF mode, or 0 for PMF mode.
  • Returns #NUM! for negative counts or negative mean values.

Examples

Poisson PMF for zero events
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.1353352832366127
Poisson CDF up to two events
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6766764161830634

Runtime metadata

Category

Statistics

Signature

POISSON.DIST(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

PHI

PHI: Returns the standard normal probability density at `x`.

PRODUCT

Multiplies all numeric arguments and returns their product.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata