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.