Statistical - NORM.S.INV Function

Description

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.

Syntax

NORM.S.INV (probability)

Arguments

Argument	Description	Required/ Optional
Probability	A probability corresponding to the normal distribution.	Required

Notes

If probability is nonnumeric, NORMS.INV returns the #VALUE! error value.
If probability <= 0 or if probability >= 1, NORMS.INV returns the #NUM! error value.
Given a value for probability, NORM.S.INV seeks that value z such that

NORM.S.DIST (z,TRUE) = probability

Thus, precision of NORM.S.INV depends on precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm