The Excel NORMSINV function calculates the inverse of the Standard Normal Cumulative Distribution Function for a supplied probability value.
The format of the function is:
Where the supplied probability is the probability value (between 0 and 1), at which you want to calculate the inverse of the standard normal cumulative distribution function.
Note that Excel uses an iterative method to calculate the Normsinv function and seeks to find a result, z, such that NORMSDIST( z ) = probability.
In the spreadsheet below, the Excel Normsinv Function is 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.
Further information and examples of the Excel Normsinv function can be found on the Microsoft Office website.
If you get an error from your Excel Normsinv 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.|