| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help picking a random number from a given distribution
If you use the function =RAND() it will generate a random number between 1
and 0. If you want it to be between 1 and 100 use =RAND()*100. "McGinty" wrote: Is there a way for me to have Excel select a random number from a given, e.g., normal distribution? Also can I put a range on the distribution? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| random number | Excel Discussion (Misc queries) | |||
| Random Number response | Excel Worksheet Functions | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Random Number Questions | Excel Worksheet Functions | |||
Threaded Mode
