Difference between revisions of "Documentation/How Tos/Calc: NORMSDIST function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→See also:) |
||
Line 20: | Line 20: | ||
[[Documentation/How_Tos/Calc: NORMDIST function|'''NORMDIST''']], | [[Documentation/How_Tos/Calc: NORMDIST function|'''NORMDIST''']], | ||
[[Documentation/How_Tos/Calc: NORMSINV function|'''NORMSINV''']], | [[Documentation/How_Tos/Calc: NORMSINV function|'''NORMSINV''']], | ||
− | [[Documentation/How_Tos/Calc: NORMINV function|'''NORMINV''']] | + | [[Documentation/How_Tos/Calc: NORMINV function|'''NORMINV''']], |
+ | [[Documentation/How_Tos/Calc: PHI function|'''PHI''']] | ||
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']] | [[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']] |
Revision as of 19:03, 19 May 2008
NORMSDIST
Calculates values for the cumulative distribution function of a normal distribution.
Syntax:
NORMSDIST(x)
- NORMSDIST calculates the cumulative distribution function of a standard normal distribution with mean μ = 0 and standard deviation σ = 1.
- It is equivalent to NORMDIST(x; 0; 1; 1).
Example:
NORMSDIST(0)
- returns 0.5. The standard normal distribution curve is centred on 0, hence half of the curve is below 0.
NORMDIST(0; 0; 1; 1)
- also returns 0.5.
See also:
NORMDIST, NORMSINV, NORMINV, PHI
Issues:
- The forthcoming international standard ODFF regards this as a legacy function, preferring NORMDIST.