The standard deviation represents how spread out around the distribution is around the mean. The mean represents the center or "balancing point" of the distribution. The normal PDF is a bell-shaped probability density function described by two values: the mean and standard deviation. If the cumulative flag is set to FALSE, the return value is equal to the value on the curve. If the cumulative flag is set to TRUE, the return value is equal to the area to the left of the input. The output of the function is visualized by drawing the bell-shaped curve defined by the input to the function. If the cumulative flag is set to FALSE, as in NORM.DIST(5,3,2,FALSE), the output is 0.121 which corresponds to the point on the curve at 5. For example, NORM.DIST(5,3,2,TRUE) returns the output 0.841 which corresponds to the area to the left of 5 under the bell-shaped curve described by a mean of 3 and a standard deviation of 2.
The NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF).
0 kommentar(er)
