Random Number Generators... ?

Reply #10

hypersoniq — Thu, 03 Jul 2003 17:19:08 GMT

thanks Everett

Reply #9

everett — Thu, 03 Jul 2003 16:43:34 GMT

Interesting topic...The page color=#0000cchttp://dada.perl.it/shootout/random_allsrc.html shows actually a basic Pseudorandom Number Generator in many different scripting languages. According to the shootout they all come up with exaclty the same number results.For the standard user the random numbers implemented in javascript, VB, Excel etc. should usually not require to program your own Random Generating Routine. If the programming language that you are using does not have a random functio... [ More ]

Reply #8

everett — Thu, 03 Jul 2003 16:25:15 GMT

Hank,Curious: What is the signifcance of=MOD((INT(RAND()*10)+1),10)Seems too big of a formula to create numbers between 0 and 9.What you are doing is, with the +1 is creating numbers between 1 and 10. Once you hit a 10 the Modulo 10 makes it a 0 again.The simpler version =INT(RAND()*10) would do the same thing.Or do I miss something?Good LuckME

Reply #7

RJOh — Mon, 23 Jun 2003 14:47:11 GMT

That site shows that there are lots of ideas to formulate a RND fuction. If you want to test your RND fuction just write a loop of maybe 1000 cycles to generate numbers 1-10 and count them. The count for each number should be pretty close, if not then your random picks are bias.RJOh

Reply #6

OldHank — Sun, 22 Jun 2003 12:35:01 GMT

Boy! That looks r-e-a-l interesting.I would definately be the dummy on that one. It's a little over my head.Maybe RJOH can help.Good luck.

Reply #5

hypersoniq — Sun, 22 Jun 2003 12:15:55 GMT

http://dada.perl.it/shootout/random_allsrc.html seems to cover all the bases... Now if it only had a for dummies guide...

Reply #4

OldHank — Sun, 22 Jun 2003 10:51:45 GMT

Check out this site:http://www-user.tu-chemnitz.de/~anhe/DOCU/C/C/FUNCTIONS/rand.htmlIt has some stuff on it about the seed.Or, you can do a search in Google rand function Good luck and please post if you find your answer.Thanks

Reply #3

OldHank — Sun, 22 Jun 2003 10:47:30 GMT

I use this formula for Pick3:=MOD((INT(RAND()*10)+1),10)The clock thing sounds logical to me.Although, you've got me thinking about it. I believe I'll do some checking and see what I can find out.Thanks

Reply #2

hypersoniq — Sun, 22 Jun 2003 10:14:21 GMT

For excel, I enter the following (for example) to generate a red ball pick...RAND()*(42-1)+1I'm just interested to see the code behind the RAND() function

Reply #1

RJOh — Sun, 22 Jun 2003 02:11:24 GMT

When a program is written, any seed number can be entered by the programmer for testing, however after program is completed, a routine may be included to get a random seed from the computer clock. If Excel doesn't give you the option of entering your own seed then it probably use the computer clock. Check your manual, it may have a way for you to formulate your own seed for testing.RJOh

Random Number Generators... ?

hypersoniq — Sat, 21 Jun 2003 22:43:07 GMT

Anyone know what's under the hood of most RNG functions?Any way to reverse-solve a number to find it's seed? Anyone know the code for how excel's RAND() function works