Random Number Generation AddON

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Is there a limit to the number you can enter in the 'Number of Random
Numbers' filed. I have 144017 records that I want to generate a random
number on and I get an 'Interger is Invalid' popup message. It seems to work
for anything under 30000 records
 
If (as seems likely) the code were programmed using the Integer data type,
then the maximum number of values would be 2^15 = 32768

You can use the RAND() worksheet function to generate as many uniform(0,1)
random numbers as you need. Moreover, the RAND() function uses a better
random number generator than the ATP tool.

You can wrap RAND() with the appropriate inverse cumulative distribution to
generate random numbers from other distributions, e.g.
=NORMINV(RAND(),mean,sd,TRUE)
would generate normal random numbers.

Jerry
 
Back
Top