WorksheetFunction.Norm_S_Inv Method
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Norm_S_Inv ( _
Arg1 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim returnValue As Double
returnValue = instance.Norm_S_Inv(Arg1)
double Norm_S_Inv(
double Arg1
)
Parameters
Arg1
Type: System.DoubleProbability - A probability corresponding to the normal distribution.
Return Value
Type: System.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.