How to save random numbers?

[Rangemaster]

Hi folks,

Hopefully someone can help me with this question - it bothers me fo
hours now and I can't find the answer anywhere on the WWW.

I'm making an excel file with a statistic experiment for students. I
involves grabbing balls out of a vase, like the example in almost an
maths book. A random number determines the color of a grabbed ball - s
far so good. But I'm not able to make a cumulative list or summation o
the generated random numbers whatsoever. Is there any way to make
function or formula that summates the generated random numbers everytim
the number is regenerated?

For example: when the random numbers are 5, 6 and 7 after refreshin
three times, is there a formula that can tell you what the sum of thos
individual numbers is?

Hopefully my question is clear.

Thanks in advance for any help!

Cheers from Holland,

Rangemaster

 

[joeu2004]

But I'm not able to make a cumulative list or summation
of the generated random numbers whatsoever. Is there any
way to make a function or formula that summates the generated
random numbers everytime the number is regenerated?
For example: when the random numbers are 5, 6 and 7 after
refreshing three times, is there a formula that can tell
you what the sum of those individual numbers is?

Instead of "refreshing three times", put your random formula into 3 cells.
For example, =RANDBETWEEN(1,50) into A1, A2 and A3. Then the sum can be
computed in A4 with the formula =SUM(A1:A3).

Every time you press F9, a new set of 3 random numbers will be generated in
A1:A3, and A4 will be their sum.

The real problem is: that also happens every time your edit any cell in any
worksheet in the workbook, and when Excel decides to recalculate for any
other reason.

If you don't want that (most people don't), copy A1:A3 and use
paste-special-value to paste a set of random numbers into B1:B3. Then use
=SUM(B1:B3) to maintain their sum.

A1:A3 will continue to change on their own. But they will not affect your
sum (of B1:B3) unless and until you copy and paste-special-value A1:A3
again.

If you do not like that manual procedure, there are alternatives. Let me
know if you want to hear about them.

 

[framer523]

Not sure if you can see this as I'm asking 1 1/2 years later but I'd like to know how to "save" the random numbers that are generated.

I have been able to generate numbers from 1 to 100 with two decimal places but I can't figure out how to create a history of previously generated numbers. It would be nice to be able to graph them on a line graph as well so as soon as I can keep a list then that won't be a problem.

Thanks.

 

[joeu2004]

I have been able to generate numbers from 1 to 100 with two
decimal places but I can't figure out how to create a history
of previously generated numbers.

Enter the following formula into A1:

=RANDBETWEEN(100,10000)/100

Copy A1 into A2:A1000. Copy A1:A1000, then use Paste-Special-Value to put
the values (not the formulas) back into A1:A1000 or somewhere else.