Skewed Normal Distribution for Monte Carlo Simulations

Interesting question ...There is a great answer by Jackbean here....

http://www.mrexcel.com/forum/excel-q...m-numbers.html

I think you could use UDF prepared by shg - see attached file.

You may check the sources given in VBA code (have you seen them? - if not, press Alt+F11 to open VBA editor):

http://azzalini.stat.unipd.it/SN/faq.html (algorithm)
http://azzalini.stat.unipd.it/SN/Intro/intro.html (intro)

As I mentioned, I used the code prepared few years ago by one of forum gurus: http://www.excelforum.com/members/60269.html and not analysed it in detail.

Basically: fAlpha is some measure of skewness (but not skewness itself - play with fAlpha to see changes in G6 in attached file) positive alfa results in positive skewness
fLocation - in case fAlpha =0 expected value. for fAlpha <>0 another measure of central tendency, but not E itself
fScale - again for fAlpha =0 just standard deviation. For fAlpha <>0 some measure of dispersion.

By the way
Is eris_strategy = VooDoo33 or it is just a coincidence with Australia as location and recent version of Excel?

Then please observe http://www.excelforum.com/forum-rule...rum-rules.html
Namely:

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

I understand pretty well why you did it here, and will not report this post, because in my opinion this rule shall exclude such cases. but on the other hand - as it is written - we (you asking, and I answering) are acting against it.