Collection for random numbers

[Giordano Bruno]

I create a single value which is the sum of various random numbers. I repeat this up to 100,000 times and currently I insert them in a worksheet and sort the results. I can then calculate the minimum, maximum, mean, mode, 5th percentile, etc. I'm wondering if I could speed up the process by sending the results to a Collection, a Dictionary or an Array. Does anyone have any thoughts about this?

 

[Giordano Bruno]

Hi everybody. Many thanks for all the suggestions. They are greatly appreciated and I am very pleased with the answers. Yes, once I have the data sorted on a worksheet, I can easily do the other things. It had occurred to me that I might even be able to find things like the mean, minimum and fifth percentile (i.e. the 5,000th value in the 100,000 sorted list) without having to dump the values into a worksheet, but I am delighted with the impressive increase in speed. I have ticked Stephen's first reply as it gave me the answer to my initial question and I shall certainly consider upgrading to steam for my next computer.