Documentation/How Tos/Calc: NORMDIST function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 18:43, 26 April 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


NORMDIST

Calculates values for a normal distribution.

Syntax:

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

Example:

NORMDIST(70; 63; 5; 0)

returns approximately 0.03.

NORMDIST(70; 63; 5; 1)

returns approximately 0.92.

See also:

NORMINV, NORMSDIST, NORMSINV

Statistical functions

Personal tools