Documentation/How Tos/Calc: NORMDIST function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 09:34, 24 November 2009 by OOoWikiBot (Talk | contribs)

Jump to: navigation, search


Calculates values for a normal distribution.


NORMDIST(x; μ; σ; mode)

The normal distribution is an often encountered family of continuous probability distributions, with parameters μ (mean) and σ (standard deviation).
If mode is 0, NORMDIST calculates the probability density function of the normal distribution:
Calc normdist0 equation.png
If mode is 1, NORMDIST calculates the cumulative distribution function of the normal distribution:
Calc normdist1 equation.png


NORMDIST(70; 63; 5; 0)

returns approximately 0.03.

NORMDIST(70; 63; 5; 1)

returns approximately 0.92.


Personal tools