ReferenceFunctionsStatistics Functions
NORM.S.DIST
NORM.S.DIST: Returns the standard normal probability for a z-score as either a CDF or PDF value.
Summary
Use NORM.S.DIST for z-based probability lookups when the distribution has mean 0 and
standard deviation 1.
Remarks
- Set
cumulativeto a non-zero value for the cumulative distributionP(Z <= z). - Set
cumulativeto0for the probability density at exactlyz. - Accepts any real-valued
z; no domain clipping is applied. - Invalid numeric coercions propagate as spreadsheet errors.
Examples
Standard normal CDF at zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Standard normal PDF at zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.3989422804014327
Related functions
Runtime metadata
Category
Statistics
Signature
NORM.S.DIST(arg1: Number, arg2: Number)Arity
min 2, max 2
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source