Table of contents
TOC
Collapse the table of content
Expand the table of content

NORM.DIST Function

Owen Duncan|Last Updated: 8/14/2018

Returns the normal distribution for the specified mean and standard deviation.

Syntax

NORM.DIST(X, Mean, Standard_dev, Cumulative)  

Parameters

TermDefinition
XThe value for which you want the distribution.
MeanThe arithmetic mean of the distribution.
Standard_devThe standard deviation of the distribution.
CumulativeA 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

The normal distribution for the specified mean and standard deviation.

Example

EVALUATE { NORM.DIST(42, 40, 1.5, TRUE) }

Returns

[Value]
0.908788780274132

See Also

NORM.S.DIST Function
NORM.INV Function
NORM.S.INV

© 2018 Microsoft