View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yttrias yttrias is offline
external usenet poster
 
Posts: 7
Default Bias in rand for excel 07

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