WorksheetFunction.Norm_Dist Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .Norm_Dist(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, NORM_DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Return Value

Double

  • 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: awfnrmdi_ZA06051213

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

Show: