Generating random lognormally distributed numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to make a random number generator function whose output is
lognormally distributed. The worksheetfunctions.loginv is suppose to be able
to help me do this, but when I use it, I get a distribution that is
lognormal, but not with the parameters that I want.

So, for example, how would i make a random number generator that outputs
numbers according to a lognormal distribution with a mean of 10 and a std.
dev. of 5.

Thanks.
Vivek.
 
Back
Top