ReferenceFunctionsStatistics Functions

STANDARDIZE

STANDARDIZE: Returns the z-score of `x` relative to a mean and standard deviation.

Summary

STANDARDIZE computes (x - mean) / standard_dev.

Remarks

standard_dev must be strictly greater than 0.
Returns #NUM! when standard_dev <= 0.
Positive output means x is above the mean; negative output means below.
Invalid numeric coercions propagate as spreadsheet errors.

Examples

One standard deviation above the mean

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

Exactly at the mean

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

Runtime metadata

Category

Statistics

Signature

STANDARDIZE(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

SMALL

Returns the k-th smallest value in a data set.

STDEV.P

STDEV.P: Returns population standard deviation using `n` in the denominator.

On this page

Summary Remarks Examples Related functions Runtime metadata