Generating random lognormally distributed numbers

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.
 
G

Guest

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

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

Similar Threads

Generating random lognormal distribution 3
Generating lognormal equity returns 2
Produce Random Numbers 6
Non Uniform Random Number Generator 2
WorksheetFunction Class - Random values from LogInv needed 5
random number generator for scientific simulation purposes 1
Is there something wrong with the random generator in Excel? 14
VBA Macro - correlations in random number generation 2

Top