Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
generating random numbers without repeats | Excel Discussion (Misc queries) | |||
Generating random numbers | Excel Worksheet Functions | |||
Generating Random numbers. | Excel Discussion (Misc queries) | |||
Generating random numbers with the occasional outlier | Excel Worksheet Functions | |||
Generating Random Number from a set of numbers | Excel Discussion (Misc queries) |