Random Number Generation AddON

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
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Repeating a RAND() function under certain conditions 0
eliminate negative value from normal random number distribution 4
random number generation help 3
Random Function for Selecting Records 3
Random number generation 4
generate a random number and use if function to generate new data 4
Generate random numbers 3
Non Uniform Random Number Generator 2

Top