Normal distribution formula - NORM.DIST

Hi community,

In Excel there is a formula NORM.DIST, yet I could not find an exact same action (formula) in EasyMorph.
Should I manually make a project (or a module) for this formula?
Do you have any good idea?
It would be great if this formula could be developed in future. Thanks!

image

image

Hi Cambridge,

There is no function for the normal distribution. However, it looks like you can calculate it in EasyMorph relatively easily. The standard deviation can be computed using the “Statistical aggregation” action. The functions exp(), pi(), and pow() would be of help too.

Many thanks dgudkov.

Just for sharing purpose, here is my formula:

exp(-0.5*square(([Value]-[Average])/[STDEV.P]))/([STDEV.P]*sqrt(2*pi()))

Validated with some sample data, looks good.

2 Likes

Thank you for posting the final formula and the validation!