For background and context, please see the following EE Question:
http://www.experts-
exchange.com/Software/Offi
ce_Productivity/Office_Suites/MS_Office/Excel/Q_28020212.html#a38854251 where the Accepted Solution is =INT(RAND()*(122-65+1)+65)
I've now expanded the range to be from 48 to 122 as in =INT(RAND()*(122-48+1)+48).
How I would use the Accepted Solution to generate a table of integer random numbers in the range of 48 to 122, like in my previous EE question, but where there are (let's say
3 or 4) sub ranges within -- and that each sub range has a specified weight/bias (Bias) for appearing in the table. I'm thinking of: (1) Using the Accepted Solution to generate
random integers in the range of 0 to 9, =INT(RAND()*(9-0+1)+0, for each column (in a new Exterior Row above the table) and for each row (in a new Exterior Column left of the table); AND (2) Then using for each cell in the main table an IF Function with (a) with its Test for the Bias being some range of combinations of the cell's Exterior row and Exterior cell (random integers), and (b) using the Accepted Solution in the resulting True/False results (for the 4 sub ranges in the main table).
The sub ranges could be 33 to 47, 48 to 57, 65 to 90 and 91 to 122. The respective bias
are 10, 20, 30 and 40% approximately.
I only have Excel 2003 and I'd rather not use =RANDBETWEEN(65,122), because I don't want to bother digging up my Microsoft CD's (still unpacked from moving), in order to load the Analysis ToolPak add-in.
How might this be done easily?
Thanks