RAND function - Not truelly Random?!?
Posted by John Earnhart on November 29, 2000 3:03 PM
It's come to my attention that the RAND function in
Excel does not appear to be "flat". It appears to
severely violate the run property of a truely random
number generator. It can only generate a maximum of 7
simultaneous numbers in a row. It sounds freakish,
but extensive experimentation and attempts at work-arounds
(on my part) seem to support it.
FYI, this limitation means the RAND function can never
generate a number lower than 1E-8, even though the RAND
function produces a 15 digit number.
Anyone else familiar with this? If so, any ideas on how to
work around this?