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

X

Number Number

A value at which to evaluate the function.

Mean

Number Number

The arithmetic mean of the distribution.

StandardDeviation

Number Number

The standard deviation of the distribution.

IsCumulative

Logical Logical

TRUE to return the probability that a value is at most the value of the X parameter (the cumulative distribution function). FALSE to return the height of the distribution's curve at that value (the probability density function), which is useful for plotting the distribution but is not itself a probability.

Returns

Number Number

A value for a normal distribution.

Returns a value for a normal distribution. The normal distribution is the bell curve that many measurements follow, such as heights or measurement errors. It is centered on the mean and its spread is determined by the standard deviation.

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. If heights have a mean of 63 and a standard deviation of 5, 92% of them are at most 70.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell