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:
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
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:
- #VALUE! error – Occurs if any of the given arguments is non-numeric.
- #NUM! error – Occurs when the given probability argument is less than zero or greater than one.
- The precision of NORM.S.INV depends on the precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.
