Hi, I am trying to think of ways that i can take a block of numbers say 10 col, 10 row.
I intend to somehow 'profile' a completed table of numbers and then produce a replica set but slightly different following the same profile (i dont know how else to say it.) You can see there is a trend, how can i find the relationship or trend in the column and row and then randomize a similar data set with the same characteristics. so you could have a graph for each axis and then the new numbers will increase/decrease to that but also being random to within a few or specified amount (variance) asking a lot i know but i'll get there just hoping for some pointers. Thanks[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]7:00
[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]45[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]7:30[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]67[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]8:00[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]87[/TD]
[TD]15[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]8:30[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]9[/TD]
[TD]120[/TD]
[TD]20[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]9:00[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]65[/TD]
[TD]15[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]9:30[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]32[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I intend to somehow 'profile' a completed table of numbers and then produce a replica set but slightly different following the same profile (i dont know how else to say it.) You can see there is a trend, how can i find the relationship or trend in the column and row and then randomize a similar data set with the same characteristics. so you could have a graph for each axis and then the new numbers will increase/decrease to that but also being random to within a few or specified amount (variance) asking a lot i know but i'll get there just hoping for some pointers. Thanks[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]7:00
[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]45[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]7:30[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]67[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]8:00[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]87[/TD]
[TD]15[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]8:30[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]9[/TD]
[TD]120[/TD]
[TD]20[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]9:00[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]65[/TD]
[TD]15[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]9:30[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]32[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]