WorksheetFunction.Norm_S_Dist Method
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Norm_S_Dist ( _
Arg1 As Double, _
Arg2 As Boolean _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Boolean
Dim returnValue As Double
returnValue = instance.Norm_S_Dist(Arg1, _
Arg2)
double Norm_S_Dist(
double Arg1,
bool Arg2
)
Parameters
Arg1
Type: System.DoubleZ - The value for which you want the distribution.
Arg2
Type: System.BooleanCumulative - A logical value that determines the form of the function. If cumulative is true, Norm_S_Dist returns the cumulative distribution function; if false, it returns the probability mass function.
Return Value
Type: System.Double
Remarks
If z is non-numeric, Norm_S_Dist returns the #VALUE! error value.
The equation for the standard normal density function is:
Figure 1: Equation for the standard normal density function
.jpg "Equation for the standard normal density function")