ReferenceFunctionsStatistics Functions
NORM.INV
NORM.INV: Returns the value `x` whose normal cumulative probability equals `probability`.
Summary
This function is the inverse of NORM.DIST(x, mean, standard_dev, TRUE).
Remarks
probabilitymust be strictly between0and1.standard_devmust be strictly greater than0.- Returns
#NUM!for invalid probability bounds or non-positive standard deviation. - Invalid numeric coercions propagate as spreadsheet errors.
Examples
Median probability returns the mean
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
10
One-standard-deviation quantile
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1
Related functions
Runtime metadata
Category
Statistics
Signature
NORM.INV(arg1: Number, arg2: Number, arg3: Number)Arity
min 3, max 3
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
Caps
PURE
Source