Edit

Share via


WorksheetFunction.Norm_S_Dist(Double, Boolean) Method

Definition

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.

public:
 double Norm_S_Dist(double Arg1, bool Arg2);
public double Norm_S_Dist (double Arg1, bool Arg2);
Public Function Norm_S_Dist (Arg1 As Double, Arg2 As Boolean) As Double

Parameters

Arg1
Double

Z - The value for which you want the distribution.

Arg2
Boolean

Cumulative - 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.

Returns

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

Applies to