The Excel NORM.S.DIST function returns output for the standard normal cumulative distribution (CDF) and the standard normal probability density function (PDF).
Syntax:= NORM.S.DIST(z,cumulative)
The NORM.S.DIST function syntax has the following arguments:
- Z Required. The value for which you want the distribution.
-
Cumulative Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
Example: Let’s look at some Excel NORM.S.DIST function examples and explore how to use the NORM.S.DIST function as a worksheet function in Microsoft Excel:
Example 1 – Standard Normal Density Function
Syntax: =NORM.S.DIST(A2,FALSE)
Result: 0.0175283
Based on the Excel spreadsheet above, the following NORM.S.DIST examples would return:
Syntax: =NORM.S.DIST(A3,FALSE)
Result: 0.164017364
Syntax: =NORM.S.DIST(A4,FALSE)
Result: 0.241970725
Syntax: =NORM.S.DIST(A5,FALSE)
Result: 0.352065327
Syntax: =NORM.S.DIST(A6,FALSE)
Result: 0.39894228
Syntax: =NORM.S.DIST(A7,FALSE)
Result: 0.129517596
Syntax: =NORM.S.DIST(A8,FALSE)
Result: 0
Syntax: =NORM.S.DIST(A9,FALSE)
Result: 0.129517596
Syntax: =NORM.S.DIST(A10,FALSE)
Result: 0.053990967
Example 2 – Standard Cumulative Distribution Function
Syntax: =NORM.S.DIST(A2,TRUE)
Result: 0.006209665
Based on the Excel spreadsheet above, the following NORM.S.DIST examples would return:
Syntax: =NORM.S.DIST(A3,TRUE)
Result: 0.908783313
Syntax: =NORM.S.DIST(A4,TRUE)
Result: 0.158655254
Syntax: =NORM.S.DIST(A5,TRUE)
Result: 0.308537539
Syntax: =NORM.S.DIST(A6,TRUE)
Result: 0.5
Syntax: =NORM.S.DIST(A7,TRUE)
Result: 0.933192799
Syntax: =NORM.S.DIST(A8,TRUE)
Result: 1
Syntax: =NORM.S.DIST(A9,TRUE)
Result: 0.066807201
Syntax: =NORM.S.DIST(A10,TRUE)
Result: 0.977249868
Note:
- The NORM.DIST() function refers to any normal distribution, whereas the NORMSDIST() compatibility function and the NORM.S.DIST() consistency function refer specifically to the unit normal distribution.
- #VALUE! error – Occurs when any of the given arguments is non-numeric or is a non-logical value.
- S.DIST is a special case of NORM.DIST. If we let the mean equal 0 and the standard deviation equal 1, the calculations for NORM.DIST match those of NORM.S.DIST.
- The NORM.S.DIST function was introduced in MS Excel 2010 as a replacement for the NORMSDIST function.
- The equation for the standard normal density function is:
