Hard to do? randomly

[farmer]

The number i put in cell A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible?

Farmer

 

[Gary''s Student]

Very easy:

In B1 thru B30 enter:
=RAND()

In B31 enter:
=SUM(B1:B30)

In A31 put your value

In A1 enter:
=$A$31*B1/$B$31 and copy down thru A30

A1 thru A30 will consist of random values which sum to the value in A 31.

 

[start]

Thanks alot , you people are great.
Farmer

Very easy:

In B1 thru B30 enter:
=RAND()

In B31 enter:
=SUM(B1:B30)

In A31 put your value

In A1 enter:
=$A$31*B1/$B$31 and copy down thru A30

A1 thru A30 will consist of random values which sum to the value in A 31.

 

[Bernd P]

Hello,

That's one possible solution. The distribution will almost look like
the green curve shown at:
http://www.sulprobil.com/html/randsum1.html
The maximum (meaning the most likely values) will be at A31/30.

If you like to test other possible distributions as well:

Select A1:A30 and array-enter
=A31*randsum1(1)
or
=A31*randsum1(3)

Regards,
Bernd