Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm testing random numbers for games using excel 07 generator, but there is
too much bias away from statistical expectation. For example, when two integer numbers are generated between 1 and 6, and subsequently added, the results differ from the easily predictable numbers. Sevens are consistently in short supply by about 1.5%. That's a lot! Any suggestions for better randomization in excel would be very much appreciated. -- yttrias |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random numbers but with a bias | Excel Discussion (Misc queries) | |||
how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
Goal Seek Bias | Excel Worksheet Functions | |||
excel rand() negative | Excel Programming | |||
Excel 2003-RND() vs Rand() | Excel Programming |