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.