Bias in random numbers

  • Thread starter Thread starter DavidObeid
  • Start date Start date
D

DavidObeid

Is there a simple (non-vba) way to generate random numbers within
given range of integers where some numbers have a different bias tha
others?

EG: I want to generate random numbers from 3 to 10 where the proportio
of expected 3's will be say, 5%, 4's will be 10%, 5's will be 13%, 6'
will be 15%, 7's will be 18%, 8's wil be 20%, 9's wil be 11% and 10'
will be 8%.

Thanks in advance,

Dav
 
...
...
EG: I want to generate random numbers from 3 to 10 where the proportion
of expected 3's will be say, 5%, 4's will be 10%, 5's will be 13%, 6's
will be 15%, 7's will be 18%, 8's wil be 20%, 9's wil be 11% and 10's
will be 8%.
Click to expand...

Another alternative,

=LOOKUP(RAND(),{0;0.05;0.15;0.28;0.43;0.61;0.81;0.92},{3;4;5;6;7;8;9;10})
 
Back
Top