But http://support.microsoft.com/kb/828795/ suggests RAND is OK in XL 2003
and 2007
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SteveM" wrote in message
...
On Dec 16, 2:22 pm, "Bernard Liengme"
wrote:
And what was your sample size?
--
Bernard V Liengme
Microsoft Excel MVPwww.stfx.ca/people/bliengme
remove caps from email

"yttrias" wrote in message

...

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

The flaw in the MS random number generator has been known for some
time. A description is included in this MS info sheet:

http://support.microsoft.com/kb/829208

I use a simulation package that has it's own generator. But there are
probably others you can download via a web search.

You may want to run statistical tests on ones that you are considering
for validation.

SteveM