is there any rule for random number to be picked up?

[roofi]

Dear Experts,
is there any rule for random number to be picked up?
Any Rule, Any Formulae, Any Calculation Anything, Any authentic routine
which may guess what would be the next random number?
for example if first random number is 825587 then what would be the next?
any guess plz. guess of first 2 or three digits will also be welcomed.


regards
Roofi

[Hawkeye16]

=RANDBETWEEN(0,1000000) will approximate the next random number between 0 and 1 million.

If you wanted to know how excel approximates random numbers there are many articles about the mathematics. If you want to approximate a truly random number... just bang your fist on the number keypad a few times, ask a few strangers to pick a number, close your eyes and throw a dart at a dart board, etc... There is no way to guess a truly random number (Otherwise I would have won the lottery by now).

[roofi]

Hawkeye
Ok Dear, i can understand. there is no way to guess exactly but many people give guess and their guess works then how they do the same. can you explain?

regards

[Hawkeye16]

It depends on where the random number is coming from. Is it being generated by excel, java, some other application, balls dropping (like a lottery drawing) etc? There are different ways each one works. If it is a computer software then there is an algorithm that determines the random number. It usually takes a seed number and performs calculations on it to arrive at a final "random" number. I believe some programs use certain digits of the sub seconds from the computer clock as the seed to get as random as possible... but it has been a long time since I took a programming class.

If you know where the random numbers are coming from it is easier to determine how to guess what they might be.

[Tony Valko]

Hmmm...

If you can guess what the next random number might be then it's not truly random, is it?