How to record and plot outcome of RAND excel
I have a column of numbers generated by RAND(), if the number is >.5 I -1 in the next column and if it is <.5 I +3 in the next column
Summing the +3 and -1 values gives me a total.
As the RAND() numbers change all the time what I would like to do is record the SUM each time and plot it to create a distribution graph. How can I do this?
for this ;
RAND() numbers change all the time you may pause it by Formula > calculation > manual. (:
and for your if(rand()) function.. seems not to cover if the rand() generates EXactly 0.5000000 .
Hope this helps.. ( :