View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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.