WorksheetFunction.Norm_S_Inv(Double) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 double Norm_S_Inv(double Arg1);

public double Norm_S_Inv (double Arg1);

Public Function Norm_S_Inv (Arg1 As Double) As Double

Parameters

Arg1: Double

Probability - A probability corresponding to the normal distribution.

Returns

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_Invdepends on precision of Norm_S_Dist(Double, Boolean). 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.

Applies to