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 Information
Version Added: Excel 2010
Syntax
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
Remarks
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.