Generating random lognormally distributed numbers

V

vivmaha

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

vivmaha

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

Creating a Search using a combo box and then creating a report. 4
Generating random lognormal distribution 3
Random Generator in Excel? 4
Produce Random Numbers 6
Generating lognormal equity returns 2
Non Uniform Random Number Generator 2
Generating lognormal distribution 1
Is there something wrong with the random generator in Excel? 14

Top