September 28, 2021

How to use NORM.S.DIST Function in Excel

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

NORM.S.DIST Function in Excel 1 - How to use NORM.S.DIST Function in Excel

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

NORM.S.DIST Function - How to use NORM.S.DIST Function in Excel

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:

  1. 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.
  2. #VALUE! error – Occurs when any of the given arguments is non-numeric or is a non-logical value.
  3. 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.
  4. The NORM.S.DIST function was introduced in MS Excel 2010 as a replacement for the NORMSDIST function.
  5. The equation for the standard normal density function is:
    NORM.S.DIST Function in Excel - How to use NORM.S.DIST Function in Excel
READ:  How to use MEDIAN Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *