Judging by my experience, the seed is reset
in Excel automatically.
Arcady.
=============================================
Arcady A. Novosyolov, Ph.D.
19-149, Academgorodok, Krasnoyarsk, Russia, 660036,
tel. +7 3912 495382 (business), +7 3912 498596 (home)
fax (603) 688-4664 (U.S.A. number)
mailto: anov@cc.krascience.rssi.ru
Home page: http://www.geocities.com/CapeCanaveral/Launchpad/6016/
ICQ: http://www.icq.com/38856350
-----Original Message-----
From: Richard.W.Nichols@travelers.com <Richard.W.Nichols@travelers.com>
To: casnet@lists.casact.org <casnet@lists.casact.org>
Date: Wednesday, June 16, 1999 6:50 PM
Subject: Re: Random Number Generators
>
>
>Its been years since I used APL, but back in the early 1980's I used to do a
>class on APL where I would demonstrate the random number generator to pick lotto
>numbers. I would write them down on the board after showing the APL statement
>that generated them. Later in the class I would run the same APL statement,
>and, magically, get the same answer. The point of the exercise was to
>demonstrate that the random number generator in APL always started with the same
>seed if you started in a newly opened workspace. Starting with the same seed
>meant that APL would generate the same random numbers in the same order every
>time. (Anyone know if this is still true?)
>
>We warned the actuarial students taking the class to be sure to randomize the
>seed, either by always saving the workspace after each simulation so that the
>new seed would be saved as well, or by using the clock to randomize the seed.
>We would simply pick N random numbers where N was the number of milliseconds on
>the current time.
>
>All this did nothing to fix any bias that may have been in the RNG, but it shows
>that there may be other problems as well. Anyone know if you can reset the seed
>in Excel?
>
>Rich
>
Visit the CAS Web Site at http://www.casact.org
===============================================
To subscribe or unsubscribe from CASNET:
Send an e-mail to caslists@lists.casact.org
Type in the body join casnet to subscribe
or leave casnet to unsubscribe.