Formualizer Docs
ReferenceFunctionsStatistics Functions

NORM.DIST

NORM.DIST: Returns the normal-distribution probability at `x` for a given mean and standard deviation.

Summary

Use NORM.DIST for either cumulative probabilities or point density under a non-standard normal model.

Remarks

  • Set cumulative to non-zero for P(X <= x); set it to 0 for density mode.
  • standard_dev must be strictly greater than 0.
  • Returns #NUM! when standard_dev <= 0.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Normal CDF at the mean
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5
Normal PDF at the mean
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.03989422804014327

Runtime metadata

Category

Statistics

Signature

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

NEGBINOM.DIST

NEGBINOM.DIST: Returns negative-binomial probabilities for failures observed before a target success count.

NORM.INV

NORM.INV: Returns the value `x` whose normal cumulative probability equals `probability`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata