WorksheetFunction.Norm_Dist (Excel)

Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.

If mean or standard_dev is nonnumeric, Norm_Dist returns the #VALUE! error value. If standard_dev ≤ 0, Norm_Dist returns the #NUM! error value. If mean = 0, standard_dev = 1, and cumulative = TRUE, Norm_Dist returns the standard normal distribution, Norm_S_Dist. The equation for the normal density function (cumulative = FALSE) is:

Norm_Dist (Arg1, Arg2, ..., Arg4)


Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblNorm_Dist As Double
dblNorm_Dist = WorksheetFunction.Norm_Dist(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3, Arg4:=True)

Arguments

Arg1, Arg2, ..., Arg4

Arg1 (Double) - X - The value for which you want the distribution.

Arg2 (Double) - Mean - The arithmetic mean of the distribution.

Arg3 (Double) - Standard_dev - The standard deviation of the distribution.

Arg4 (Boolean) - Cumulative - A logical value that determines the form of the function. If cumulative is True, Norm_Dist returns the cumulative distribution function; if False, it returns the probability mass function.