Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to average random cells with out counting zero? | Excel Worksheet Functions | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |