Formulae: Normal Distribution functions added

bfromson1 · April 15, 2013 5:50AM

Any chance of adding the equivalents of Excel NORMSDIST and NORMSINV to the available mathematical operators? We are looking to run capital calculations in a model and these are required.

Thanks

michael · April 18, 2013 1:28PM

Hi Bernard,

The following functions have been implemented:

NORMDIST(x, mean, sdev, cumulative)
NORMINV(probability, mean, sdev)
NORMSDIST(x, cumulative)
NORMSINV(probability)

and they shall be in tonight's build 2.8-alpha b792+.

See also http://www.visokio.com/kb/functions-guide for more information.

bfromson1 · April 19, 2013 4:56AM

Thank You

Welcome!

Categories

Ideas Parade

Tagged