Generating random lognormally distributed numbers
 

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.

Generating random lognormally distributed numbers
 

Dont worry.
The software that I use to analyse the output was faulty.
Problem solved.

"vivmaha" wrote:

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.