Spread 8.0 Documentation
NORMDIST
Support Options
Formula Reference > Built-In Functions > NORMDIST

Glossary Item Box

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.