"Glen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Some time within the last year, I read in a text (or possibly > a paper, but I am fairly confident it was in a text) discussing > random numbers what random number generator Excel uses, as well > as some comments on its attributes (some bad, some less so). > > Recently I wanted to mention the discussion in the book > in some notes I was writing. > > I thought I knew where I had seen it, but rereading the text > in question, it doesn't seem to mention Excel at all. > > Does anyone have a clue what book this might have been in? > > Glen ----------------------- I have a lengthy paper on the analysis of Excel's Stat, the faults and errors. I have a long section on analysis of RAND which was used in all versions of Excel from Excel 94 to Excel 2002. Excel 2003 changed the RNG, and I have no details. Actually RAND holds up pretty good to testing.
The paper is unpublished. Still making revisions to fit the Excel 2003 changes. Paper runs about 220 pages. Contact me for details. David Heiser . . ================================================================= Instructions for joining and leaving this list, remarks about the problem of INAPPROPRIATE MESSAGES, and archives are available at: . http://jse.stat.ncsu.edu/ . =================================================================
