Generating lognormal equity returns

S

Sheak1

Would anyone have any sample code that I can use to generate a random series
of monthly lognormal equity returns with a mean of, let's say, 8% annually
and a standard deviation of 15%. Many thanks.
 
G

Gary''s Student

I am sorry. I re-read your post. If all you want are random samples and not
the CDF, then in A1 enter:
=EXP(NORMINV(RAND(),0.08,0.15)) and copy down for as many samples as you need
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top