View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Okstate_Fan131313 Okstate_Fan131313 is offline
external usenet poster
 
Posts: 1
Default 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.