Formualizer Docs
ReferenceFunctionsStatistics Functions

NORM.S.INV

NORM.S.INV: Returns the z-score whose standard normal cumulative probability matches `probability`.

Summary

This is the inverse of NORM.S.DIST(z, TRUE) and is commonly used for critical-value thresholds.

Remarks

  • probability must be strictly between 0 and 1.
  • Returns #NUM! when probability <= 0 or probability >= 1.
  • Output can be negative, zero, or positive depending on which side of 0.5 you query.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Median probability maps to zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
Upper-tail critical z-score
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.959963986120195

Runtime metadata

Category

Statistics

Signature

NORM.S.INV(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

NORM.S.DIST

NORM.S.DIST: Returns the standard normal probability for a z-score as either a CDF or PDF value.

PEARSON

Returns the Pearson correlation coefficient between two paired numeric arrays.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata