Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how are random numbers determined
How does XLS determine random numbers? Does the sequence repeat after a
number of iterations? |
#2
|
|||
|
|||
hectorvector -
See "Description of the RAND function in Excel 2003" at http://support.microsoft.com/default...b;en-us;828795 - Mike www.mikemiddleton.com "hectorvector" wrote in message ... How does XLS determine random numbers? Does the sequence repeat after a number of iterations? |
#3
|
|||
|
|||
For earlier versions of Excel, see
http://support.microsoft.com/kb/q86523/ which has a much shorter period. Computers generate pseudo random numbers, which generally will repeat at some point. The relevant questions are how random (in multiple dimensions) are the results and how long is the period. http://groups.google.com/groups?selm...9.36e9afd8%40p... implements the 2003 algorithm in VBA. An even better algorithm is the Mersenne Twister http://www.math.sci.hiroshima-u.ac.j...at/MT/emt.html http://www.math.sci.hiroshima-u.ac.j...S/FORTRAN/fort... http://www-personal.engin.umich.edu/...neTwister.html which is implemented in the freeware NtRand http://www.numtech.com/NtRand/ Jerry Mike Middleton wrote: hectorvector - See "Description of the RAND function in Excel 2003" at http://support.microsoft.com/default...b;en-us;828795 - Mike www.mikemiddleton.com "hectorvector" wrote in message ... How does XLS determine random numbers? Does the sequence repeat after a number of iterations? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |