Formualizer Docs
ReferenceFunctionsStatistics Functions

GAUSS

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

Summary

GAUSS computes NORM.S.DIST(z, TRUE) - 0.5, preserving the sign of z.

Remarks

  • Positive z returns a positive area; negative z returns a negative area.
  • GAUSS(0) returns 0.
  • Output magnitude is always less than 0.5.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Area from mean to z = 1
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.3413447460685429
Symmetric negative z-value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-0.3413447460685429

Runtime metadata

Category

Statistics

Signature

GAUSS(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

GAMMA.DIST

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

GEOMEAN

GEOMEAN: Returns the geometric mean of positive numeric values.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata