NORMSINV Function

Basic Description

The Excel NORMSINV function calculates the inverse of the Standard Normal Cumulative Distribution Function for a supplied probability value.

Syntax: NORMSINV( probability )

Where probability 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 Normsinv function and seeks to find a result, z, such that NORMSDIST( z ) = probability.

 

Normsinv Function Examples

The spreadsheet below shows examples of the Excel Normsinv 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 Normsinv Function

 Results:

Excel Normsinv Function Results

 

Normsinv Function Errors

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

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