mxjames

New Member
Joined
Dec 28, 2012
Messages
3
Assuming I have two tables, Table 1 and Table 2:

19112040
610234449
1018232440
510252944
1016183142
1494350

<tbody>
</tbody>

Table 1, are numbers between 1 and 25 randomly selected and
Table 2, are numbers between 20 and 50 randomly selected.
I believe numbers do not lie and therefore there is a sequence between both random outputs. How can excel be used to understand the random sequence and produce more output to the sequence correctly?
 
Last edited:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

pplstuff

Well-known Member
Joined
Mar 9, 2012
Messages
951
How can excel be used to understand the random sequence and produce more output to the sequence correctly?

Well, I hope you're a mathematician by trade to recognize a closed-form solution for how excel generates its random numbers...
Pseudorandomness - Wikipedia, the free encyclopedia

I'm not sure I understand the second half of the question "and produce more output to the sequence correctly". Do you want to try and forecast the next random number? For a true stochastic process, this cannot be done; but, for a computer there might be a way to determine its method.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,798
Office Version
  1. 2010
Platform
  1. Windows
Random numbers do not correlate; you can't use one set to predict another unless they are correlated as a result of a bad algorithm, or deliberately generated as correlated pairs.

VBA's Rnd() function generates a fixed repeating sequence of 2^24-1 numbers (Singles). Excel's RAND() function generates a much longer sequence (~2^44) of Doubles, and unlike Rnd(), cannot be seeded to start with a certain number.
 

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,257
Maybe/Probably it's me, but I don't understand what you are asking exactly. I don't know what you mean by "a sequence between both random outputs" and your expectation to "produce more output to the sequence correctly".

Perhaps this link to Chip Pearson's page on random numbers may help, but if not, some additional explanation would help readers of this page to understand what kind of result you are looking to achieve.

http://www.cpearson.com/excel/RandomNumbers.aspx
 

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,257

ADVERTISEMENT

More about this:

Random numbers are based on a predictable algorithm. If you know the previous number and the algorithm, you can predict the next number(s) generated by the random function. This sounds counter-intuitive, but that's because random numbers which are generated by computers are not truly random. A computer uses something called a "random number generator" to produce a series of numbers that satisfy what most people would need for randomness, but really, the numbers are not random.

You can test this for yourself. Run this macro on a blank worksheet. It will produce two columns of 1000 rows each of random numbers. In a truly random environment, what would be the odds of any one pair of rows (that is, for example, the value in cell A346 equaling the value of cell B346)? What would be the odds of ALL 1000 equaling each other? You and I would have better luck winning the Powerball lottery jackpot on a day when there's world peace. Run this macro to see just how "random" random numbers are, and are not.

Code:
Sub Test1() 
Dim x As Long 
Rnd -1 
Randomize 1 
For x = 1 To 1000 
Cells(x, 1).Value = Rnd 
Next x 
Rnd -1 
Randomize 1 
For x = 1 To 1000 
Cells(x, 2).Value = Rnd 
Next x 
End Sub
 

mxjames

New Member
Joined
Dec 28, 2012
Messages
3
The numbers are selected randomly from the sets. There is definitely an attitude of selection the computer uses. My question is how do I understand the computers method of selection when to hand I have samples of its output in that random sequence?
 

mxjames

New Member
Joined
Dec 28, 2012
Messages
3
Assuming I have two tables,

Table 1 = RAND(1,25) and Table 2=RAND(20,50)

19112040
610234449
1018232440
510252944
1016183142
1494350

<tbody>
</tbody>

Table 1, are numbers between 1 and 25 randomly selected and
Table 2, are numbers between 20 and 50 randomly selected.
I believe numbers do not lie and therefore there is a sequence between both random outputs.
How can excel be used to understand the random sequence and produce more outputs of the sequence correctly?
HINT=(The numbers are selected randomly from the sets. There is definitely an attitude of selection the computer uses. My question is how do I understand the computers method of selection. The tables are samples of its selection process (row by row))
 

Forum statistics

Threads
1,137,349
Messages
5,680,963
Members
419,946
Latest member
Trickay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top