sorting 100 000 random numbers in ONE column (excel)
sorting 100 000 random numbers in ONE column (excel)
(OP)
Hello
I need 100 000 random numbers, following a normal distribution. I tried using excel, tools, generate random numbers... the problem is: it works for 30 000, but not much more than that. I tried doing 4 times 25 000 numbers. that works, but i then need to sort all the numbers, and i cant paste all the results in ONE column. The max seems to be around 60 000 or so.. Is that excel's limit? Is there any other way to do it?
thanks
I need 100 000 random numbers, following a normal distribution. I tried using excel, tools, generate random numbers... the problem is: it works for 30 000, but not much more than that. I tried doing 4 times 25 000 numbers. that works, but i then need to sort all the numbers, and i cant paste all the results in ONE column. The max seems to be around 60 000 or so.. Is that excel's limit? Is there any other way to do it?
thanks





RE: sorting 100 000 random numbers in ONE column (excel)
Use VB, generate them and sort them into two columns, one less than 0.5, then cut and paste them into whatever analysis program.
That's a fairly cumbersome approach, you'd be better off using a better stats package, R, scilab, octave are all free and will handle massive amounts of data and I am sure theyll generate suitable random numbers.
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: sorting 100 000 random numbers in ONE column (excel)
RE: sorting 100 000 random numbers in ONE column (excel)
...Or you could wait for Excel 2007 which will have plenty more than 100,000 rows.
RE: sorting 100 000 random numbers in ONE column (excel)
Dik
RE: sorting 100 000 random numbers in ONE column (excel)
it is in fact a montecarlo simulation.. i'll try and look into other applications. just hope i can figure out how to use them properly
RE: sorting 100 000 random numbers in ONE column (excel)
If so, perhaps you could limit your spreadsheet to 50,000 rows, and run it twice?
RE: sorting 100 000 random numbers in ONE column (excel)
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: sorting 100 000 random numbers in ONE column (excel)
TTFN
RE: sorting 100 000 random numbers in ONE column (excel)
RE: sorting 100 000 random numbers in ONE column (excel)