NORM.S.INV Function

Basic Description

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.

 Formulas:

Examples of use of the Excel Norm.S.Inv Function

 Results:

Excel Norm.S.Inv Function Results

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

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment