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.
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:
Based on the Excel spreadsheet above, the following NORM.S.INV examples would return:
- #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.