Поделиться через

WorksheetFunction.NormDist Method

  • Статья
Excel Developer Reference

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

Syntax

expression.NormDist(Arg1, Arg2, Arg3, Arg4)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data Type Description
Arg1 Required Double X - the value for which you want the distribution.
Arg2 Required Double Mean - the arithmetic mean of the distribution.
Arg3 Required Double Standard_dev - the standard deviation of the distribution.
Arg4 Required Boolean Cumulative - a logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Return Value
Double

Remarks

  • If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.

  • If standard_dev ≤ 0, NORMDIST returns the #NUM! error value.

  • If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST.

  • The equation for the normal density function (cumulative = FALSE) is:

    Equation

  • When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.

See Also