Is the RANBETWEEN function certified randomness?
You can test it depending on the range of numbers you're generating.
For example:
For random numbers from 1 to 10
Select the range A1:A20000
Enter the formula =RANDBETWEEN(1,10)
Hit CTRL ENTER
Enter this formula in C1 and copy down to C10:
=COUNTIF(A:A,ROW())
The initial calculation will take a few seconds to calculate. You will get a
relatively uniform distribution with no extreme outliers.
To generate a new set of data just press F9
--
Biff
Microsoft Excel MVP
"Candicehkjc" wrote in message
...
We use the RANBETWEEN function to generate random numbers, is this
function
certified randomness?
|