NORM.DIST function

NORM.DIST(X, Mean, StandardDeviation, IsCumulative) NORM.DIST(X; Mean; StandardDeviation; IsCumulative)

X

Number or { Number }

A value at which to evaluate the function.

Mean

Number or { Number }

The arithmetic mean of the distribution.

StandardDeviation

Number or { Number }

The standard deviation of the distribution.

IsCumulative

Logical or { Logical }

FALSE to calculate the probability mass function and TRUE to calculate the cumulative distribution function.

Returns

Number or { Number }

A value for a normal distribution.

Returns a value for a normal distribution.

Examples

NORM.DIST(70, 63, 5, FALSE)NORM.DIST(70; 63; 5; FALSE)

Returns roughly 0.030.

NORM.DIST(70, 63, 5, TRUE)NORM.DIST(70; 63; 5; TRUE)

Returns roughly 0.92.