| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
random numbers but normal distribution
Thank you Sir!
Works great!!! "Lars-Ã…ke Aspelin" wrote: On Mon, 4 Aug 2008 21:15:01 -0700, Albert wrote: Hello! I'm trying to get a list of 10,000 numbers with average 0.5 and a starndard deviation 0.2. Does someone know how to do this? Any ideas? I'd like a function to create "random" numbers but with function parameters "Average" and "StDev". I thank you in advance... Albert C. Try this formula in any cell =NORMINV(RAND(),0.5,0.2) Copy the formula down, or in any other preferred direction, to get your 10000 numbers. Hope this helps / Lars-Ã…ke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| eliminate negative value from normal random number distribution | Excel Worksheet Functions | |||
| Special Random Numbers' Distribution | Excel Discussion (Misc queries) | |||
| draw random from normal distribution | Excel Discussion (Misc queries) | |||
| How do you generate random numbers in a normal distribution? | Excel Programming | |||
| normal distribution of random no.'s | Excel Programming | |||
Threaded Mode
