Weighting random allocations within a range

[Guest]

Int((8 - 1 + 1) * Rnd + 1), randomly generate a number between 1 and 8.
I am populating a column with those random results.
How could enhance this to weight more 1s than 2s, more 2s than 3s and so on?

Appreciatively,
Arturo

 

[Tom Ogilvy]

One way:

You would need to make a step distribution that divides the interval between
0 and 1 into 8 sections to fit the proportion of the values you want - and
then possibly use it with a vlookup or lookup function.

 

[Peter T]

On the off chance - if this relates to Benford's Law * try some of the
formulas here:

http://mathworld.wolfram.com/BenfordsLaw.html

* random 1's occur more frequently than 2's etc, it seems in some
situations.

Regards,
Peter T

 

[Bernd Plumhoff]

If you have equidistant slices, take my function Redw(),
for example (see:
http://www.sulprobil.com/html/random_numbers.html
). If your slices are not equidistant, you might take my
function Rww().

HTH,
Bernd

 

[Guest]

Thank You Guys!