NormDist
|
Statistical functions |
SYNTAX | NormDist( x, mean = 0, sigma = 1, cumulative = True ) |
RETURNS | NUMBER |
FUNCTION | The function calculates Normal distribution The function uses hi-precision algorithm that gives accurate results even for extreme left and right tails (<-5 and >+5) The results are compatible with Excel 2003 and later which introduced higher precision NORMDIST than previous versions (Excel 2002 and earlier).
|
EXAMPLE | x = 19; |
SEE ALSO |
The NormDist function is used in the following formulas in AFL on-line library:
See updated/extended version on-line.