Weighted how?

Here's one way to get a distribution weighted toward 0. Select A1:A200,
and array-enter (CTRL-SHIFT_ENTER or CMD-RETURN):

=INT(RAND()*RAND()*7)+1

conversely, weighted toward 7 (also array-entered):

=7-INT(RAND()*RAND()*8)

You could also enter regularly each formula in cell A1 and copy down.

In article ,
"giles" wrote:

I want to generate sample data - maybe 200 numbers from 1 to 7 but wieghted
towards one end - any ideas?