If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Non-random numbers generated by excel's data analysis random gener
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 |
#2
|
|||
|
|||
Allie wrote...
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. First, this isn't the appropriate newsgroup for this detailed level of Excel functionality. You'd be better off posting in microsoft.public.excel.misc, to which I've cross-posted this reply. This is a know problem. See http://groups.google.com/group/micro...36f9fec558b658 (or http://makeashorterlink.com/?G2C0129CB ). |
#3
|
|||
|
|||
Thanks for your response, Harlan. Your link doesn't seem to be the same
issue I am talking about here. The link says that large arrays can get non-random, and that there are repeat sequences within 500 tries. The apparent bug I noticed is not that. And apologies for posting in an inappropriate place. Allie |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Non-random numbers generated by excel's data analysis random gener | Harlan Grove | General Discussion | 2 | September 13th, 2005 04:06 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |