Navigation:  Formula Reference > Spreadsheet Formula Functions >

NORMDIST

Previous pageReturn to chapter overviewNext page

 

This function returns the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORMDIST(x,mean,stdev,cumulative)

Arguments

This function has these 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.

Remarks

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

Data Types

The x, mean, and stdev arguments accept numeric data. The cumulative argument accepts logical data. Returns numeric data.

Examples

NORMDIST(10,A3,B17,FALSE)

NORMDIST(10,R3C1,R17C2,FALSE)

NORMDIST(37,41.125,9.86,TRUE) gives the result 0.3378810361

 

See Also

NORMINV

NORMSDIST