The Excel NORM.S.INV function calculates the inverse of the Standard Normal Cumulative Distribution Function for a supplied probability value. The Norm.S.Inv function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the function is simply a new version of the Normsinv function that is available in earlier versions of Excel.
Syntax: NORM.S.INV( probability )
Where the probability argument is the probability value (between 0 and 1), for which you want to calculate the inverse of the standard normal cumulative distribution function.
Note that Excel uses an iterative method to calculate the Norm.S.Inv function and seeks to find a result, z, such that:
NORM.S.DIST( z, TRUE ) = probability
Norm.S.Inv Function Examples
The spreadsheet below shows examples of the Excel Norm.S.Inv Function, used to calculate the inverse of the Standard Normal Cumulative Distribution Function for 3 different probability values. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Norm.S.Inv Function Errors
If you get an error from your Excel Norm.S.Inv function this is likely to be one of the following:
|#NUM!||–||Occurs if the supplied probability argument is ≤ 0 or ≥ 1|
|#VALUE!||–||Occurs if the supplied probability argument is non-numeric|