Excel's Rand() Function
Hi,
I had a couple of questions about rand() function accuracy (randomness). 1. Is there a difference between rand() in excel 97 and 2003 in terms of randomness. Is 2003 better? 2. Does anyone have links to improved "rand" functions based on the Messene twister or other logic. Is there some place to download random numbers between 0,1 that I can test rand() against? Thanks for your help on this. |
Excel's Rand() Function
1. Yes and yes.
2. Yes. http://groups.google.com/group/micro...5cf4ff137506ea Jerry "Jeff" wrote: Hi, I had a couple of questions about rand() function accuracy (randomness). 1. Is there a difference between rand() in excel 97 and 2003 in terms of randomness. Is 2003 better? 2. Does anyone have links to improved "rand" functions based on the Messene twister or other logic. Is there some place to download random numbers between 0,1 that I can test rand() against? Thanks for your help on this. |
All times are GMT +1. The time now is 09:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com