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?

Answers


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.. ( :


Need Your Help

header & footer positions not fixed when calling external HTML page in index.html page?

jquery android jquery-mobile

I have a problem with header &amp; footer while calling one external html page in my index.html page in jquery mobile. Here is the sample code which I am following:

database backup with cron jobs in cpanel

mysql cron mysqldump cpanel

I am trying to take back up in my cpanel using cron jobs.