View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Generating lognormal equity returns

use the
=LOGNORMDIST() function in the worksheet
--
Gary''s Student - gsnu200725


"Sheak1" wrote:

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.