NORMDIST function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
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:
- If mode is 1, NORMDIST calculates the cumulative distribution function of the normal distribution:
Example:
NORMDIST(70; 63; 5; 0)
- returns approximately 0.03.
NORMDIST(70; 63; 5; 1)
- returns approximately 0.92.
See Also
