How to use NORM.S.INV Function in Excel

The NORMS.S.INV function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax:= NORM.S.INV(probability)

The NORM.S.INV function syntax has the following arguments:

  • Probability     Required. A probability corresponding to the normal distribution.

Example: Let’s look at some Excel NORM.S.INV function examples and explore how to use the NORM.S.INV function as a worksheet function in Microsoft Excel:

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

To calculate the inverse of the Standard Normal Cumulative Distribution Function, we will use the following formula:

Syntax:  =NORM.S.INV(A2)

Result: -0.67448975

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

Based on the Excel spreadsheet above, the following NORM.S.INV examples would return:

Syntax: =NORM.S.INV(A3)
Result: 0.125661347

Syntax: =NORM.S.INV(A4)
Result: 1.281551566

Syntax: =NORM.S.INV(A5)
Result: 1.644853627

Syntax: =NORM.S.INV(A6)
Result: 0

Syntax: =NORM.S.INV(A7)
Result: 0.67448975

Syntax: =NORM.S.INV(A8)
Result: #NUM!

Syntax: =NORM.S.INV(A9)
Result: #NUM!

Syntax: =NORM.S.INV(A10)
Result: #NUM!

Note:

  1. #VALUE! error – Occurs if any of the given arguments is non-numeric.
  2. #NUM! error – Occurs when the given probability argument is less than zero or greater than one.
  3. The precision of NORM.S.INV depends on the precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.

 

READ:  How to use TREND Function in Excel

Add a Comment

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