Bias in random numbers

[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

 

[Juan Pablo González]

Well, a 'simple' approach using Excel's RAND() function (and not VBA based)
can be found here:

http://www.mrexcel.com/board2/viewtopic.php?t=51538

 

[Harlan Grove]

...
...

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%.

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})