Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random generator using a range with range frequency
I'm trying to find a way to randomly choose a number within a given range but
have a given frequency for each random number. For example. Range: 1-5 Frequency of appearance: 1=5% 2=10% 3=30% 4=50% 5=5% I was trying to find a way using the random function with upper & lower bounds but wasn't sure how in incorporate the "frequency of appearance" factor. Any and all help is greatly appreciated, Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range generator | Excel Programming | |||
Random Generator | Excel Discussion (Misc queries) | |||
Random Name Generator | Excel Worksheet Functions | |||
Random Number Generator | Excel Worksheet Functions | |||
Random # Generator | Excel Worksheet Functions |