NORMDIST

---

Name

Normal distribution

Description

Returns the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORMDIST(x,mean,stdev,cumulative)

Remarks

If mean = 0 and stdev = 1, this function returns the standard normal distribution, NORMSDIST.

This function has the following arguments:

Argument	Description
x	Value for which to find the distribution
mean	Arithmetic mean of the distribution
stdev	Standard deviation of the distribution. Must be greater than zero
cumulative	Set to TRUE to return the cumulative distribution function. Set to FALSE to return the probability mass function

Data Type

The x, mean, and stdev arguments accept numeric data. The cumulative argument accepts logical data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

NORMDIST(10,A3,B17,FALSE)
NORMDIST(10,R3C1,R17C2,FALSE)
NORMDIST(37,41.125,9.86,TRUE)=0.3378810361