Formualizer Docs
ReferenceFunctionsStatistics Functions

GAMMA.DIST

GAMMA.DIST: Returns the gamma-distribution probability at `x` for shape `alpha` and scale `beta`.

Summary

GAMMA.DIST supports cumulative and density modes for right-skewed waiting-time models.

Remarks

  • Requires x >= 0, alpha > 0, and beta > 0.
  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Returns #NUM! when any parameter is outside its valid range.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Gamma CDF with alpha=1 and beta=2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6321205588285577
Gamma PDF with alpha=1 and beta=2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.18393972058572117

Runtime metadata

Category

Statistics

Signature

GAMMA.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

FREQUENCY

Returns a vertical frequency distribution for numeric data across bin cutoffs.

GAUSS

GAUSS: Returns the standard normal area between `0` and `z`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata