Partially randomized numbers

[Bob1980]

Hi All,

I want to make a VB Script that will allow me to partially randomize numbers. What I mean by this is, I want the script to spit out values, which are defined by a range, and who's frequency is dependent on a standard curve, or probability curve.

For Instance:
range 1-100
values 1-10, 5% of the time
values 11-90, 20% of the time
values 91-100, 75% of the time

Thanks!

[shg]

How about just a formula?

=CHOOSE(MATCH(RAND(), {0,5,25}%), randbetween(1,10), randbetween(11,90), randbetween(91,100))

RANDBETWEEN requires the Analysis Toolpak in Excel 2003.