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
 

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

PHP lottery number generator 0
random number generator 6
eliminate negative value from normal random number distribution 4
Excel Repeating a RAND() function under certain conditions 0
Non Uniform Random Number Generator 2
Random numbers, letters, pictures? 6
How random is Rnd 11
Anyone else had a huge increase of spam emails (Gmail) yesterday? 15

Back
Top