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.