Rand() in excel 2000

[Bazman]

Hi there,

Currently my excel rand function when called in VBA repeatedly produces a random value of circa 1.788*10-7.

When this is fed into NormInv(1.788*10-7,0,1).

I get -5,000,000.

Surely this figure is too small to occur relatively fequently?

Its occus every approx 4000 times rand is called?

I heard that the rand() in earlier version of excel could be ropey is this an example? If so how do I fix or what alternatives do I have?

Thanks

Baz

[Aussiebear]

"ropey".... What is this supposed to mean?

[Bazman]

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

earlier version of rand() were found to fail statistical tests of randomness it was updated in excel 2003 and 2007

[GTO]

Greetings,

Well beyond my understanding; I have never used norminv and wouldn't have a clue... I did happen to trip upon this, see if post 83 means anything to you. http://www.forexfactory.com/showthread.php?t=227918&page=6

As to another random number generator, again, beyond me, but this looked interesting: http://www.ntrand.com/

Hope of some help,

Mark