Formualizer Docs
ReferenceFunctionsStatistics Functions

EXPON.DIST

EXPON.DIST: Returns the exponential-distribution probability at `x` for rate `lambda`.

Summary

Use EXPON.DIST for waiting-time models where events occur with a constant hazard rate.

Remarks

  • Requires x >= 0 and lambda > 0.
  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Returns #NUM! when inputs violate domain requirements.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Exponential CDF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6321205588285577
Exponential PDF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.36787944117144233

Runtime metadata

Category

Statistics

Signature

EXPON.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

DEVSQ

DEVSQ: Returns the sum of squared deviations from the mean.

F.DIST

F.DIST: Returns the F-distribution probability for `x` with numerator and denominator degrees of freedom.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata