View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Dude The Dude is offline
external usenet poster
 
Posts: 10
Default Always the same average for random numbers!?

Hello :)

I am using a random number generation with a Randomize statement at the
beginning of the procedure.
My formula is Int ( 10 * Rnd + 1 ) to get a number between 1 and 10.

Thing is I have been trying this formula on 30 * 65536 cells and for each
session I get a 6.11 average. Most of the time it changes after the third
figure (like 6.114 instead of 6.112) but I am very surprised by the
similarity of the results...

Is that supposed to happen or am I doing something wrong?

Thanks
T_D