Expand Minimize

WorksheetFunction.Norm_S_Inv Method (Excel)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.

Version Added: Excel 2010

expression .Norm_S_Inv(Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Probability - A probability corresponding to the normal distribution.

Return Value

Double

  • If probability is non-numeric, NORM_S_INV returns the #VALUE! error value.

  • If probability < 0 or if probability > 1, NORM_S_INV returns the #NUM! error value.

Given a value for probability, NORM_S_INV seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of NORM_S_INV depends on precision of NORM_S_DIST. NORM_S_INV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.

Community Additions

ADD
Show:
© 2014 Microsoft