Difference between revisions of "Documentation/How Tos/Calc: NORMSDIST function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Issues:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 19: | Line 19: | ||
: also returns 0.5. | : also returns 0.5. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[Documentation/How_Tos/Calc: NORMDIST function| | + | * [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]], |
| − | [[Documentation/How_Tos/Calc: NORMSINV function| | + | * [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]], |
| − | [[Documentation/How_Tos/Calc: NORMINV function| | + | * [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]], |
| − | [[Documentation/How_Tos/Calc: PHI function| | + | * [[Documentation/How_Tos/Calc: PHI function|PHI]] |
| − | [[Documentation/How_Tos/Calc: Statistical functions| | + | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
=== Issues: === | === Issues: === | ||
| Line 34: | Line 34: | ||
* The accuracy is insufficient for x < −2. The error will hopefully be fixed in OOo3.2. You should use the equation | * The accuracy is insufficient for x < −2. The error will hopefully be fixed in OOo3.2. You should use the equation | ||
:<tt>NORMSDIST(x) = 0.5 * ERFC(-x/SQRT(2))</tt> for x < −2. | :<tt>NORMSDIST(x) = 0.5 * ERFC(-x/SQRT(2))</tt> for x < −2. | ||
| − | :The function [[Documentation/How_Tos/Calc: ERFC function|ERFC]] belongs to the category ''Add-in''. | + | :The function * [[Documentation/How_Tos/Calc: ERFC function|ERFC]] belongs to the category ''Add-in''. |
Revision as of 14:07, 25 February 2009
NORMSDIST
Calculates values for the cumulative distribution function of a normal distribution.
Syntax:
NORMSDIST(x)
- The standard normal distribution is a normal distribution with mean μ = 0 and standard deviation σ = 1.
- NORMSDIST calculates the cumulative distribution function of the standard normal distribution.
- 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.
Template:Documentation/SeeAlso
Issues:
- The forthcoming international standard ODFF regards this as a legacy function, preferring NORMDIST.
- The accuracy is insufficient for x < −2. The error will hopefully be fixed in OOo3.2. You should use the equation
- NORMSDIST(x) = 0.5 * ERFC(-x/SQRT(2)) for x < −2.
- The function * ERFC belongs to the category Add-in.
