NORMSDIST
Returns the standard normal cumulative distribution at z (legacy name).
NORMSDIST(z) is NORM.S.DIST(z, TRUE): the compatibility form has no
cumulative argument and always returns the cumulative probability.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=NORMSDIST(z)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
z | number | Required | — |
How it works
Maps to NORM.S.DIST with cumulative set to TRUE. Integrates the standard normal density from negative infinity to z, for any real z.
Error cases
- A non-numeric
zreturns#VALUE!.
Examples
Use the legacy name to integrate standard-normal density up to 0.5.
Formula =NORMSDIST(0.5)
Expected result 0.691462461274013
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Move the cutoff up to 0.75 standard deviations above the center.
Formula =NORMSDIST(0.75)
Expected result 0.773372647623132
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
At 0.01 the lower-tail area slightly exceeds one half.
Formula =NORMSDIST(0.01)
Expected result 0.503989356314632
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
The input must be numeric.
Formula =NORMSDIST("invalid")
Expected result #VALUE!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the cumulative standard normal probability at z = 1.333333.
Formula =NORMSDIST(1.333333)
Expected result 0.908788725604095
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.