Re: Non-random numbers generated by excel's data analysis random gener
- From: "Mike Middleton" <middleton@xxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Sep 2005 00:48:57 -0700
Allie -
See "Description of the effects of the improved statistical functions for
the Analysis ToolPak in Excel 2003 and in Excel 2004 for Mac," at
http://support.microsoft.com/default.aspx?scid=kb;en-us;829208
specifically, the "Random Number Generation" section.
- Mike
www.mikemiddleton.com
"Allie" <Allie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:022013BF-36F2-4F09-9244-1E6FA3340BFF@xxxxxxxxxxxxxxxx
> Hi,
>
> I've been trying to generate random numbers using excel's random number
> generator in the analysis toolpak. I'm using Uniform number generation
> between 0 and 1, and I am using a random seed, as I would like to be able
> to
> re-generate the same numbers in the future.
>
> Using seeds from 1 to 10, when i fill a range of 16 cells with random
> numbers, the first cell filled is always the lowest. This is an extremely
> unlikely circumstance with a true RN generator. I just wanted to raise
> this
> flag, as it could be affecting others without their knowledge.
>
> Thanks,
> Allie
>
.
- References:
- Prev by Date: Re: finding name within range
- Next by Date: Re: Avoiding #NUM!
- Previous by thread: Re: Non-random numbers generated by excel's data analysis random gener
- Next by thread: Re: Non-random numbers generated by excel's data analysis random gener
- Index(es):
Relevant Pages
|
