Only for statistical dynamics geeks. An experiment I did on a spreadsheet. In the 2nd chart, the selection range for a random number shifted upward only 2%, and only when there was a superior neighbor on the left, yet note that even this modest increase in competitiveness significantly affected overall results. Results were essentially the same over several trials (refreshes).
 Table OneFormula A1:CW1 -> =RANDBETWEEN(-50;50). Formula A2:CW500 -> =RANDBETWEEN(A1[RELATIVE]-25;A1[RELATIVE]+25). Blue Squares -> Values more than 100. Red Squares -> Values less than -100. Line Graph -> Average value across each row 1-500. |
 Table TwoFormula A1:CW1 -> =RANDBETWEEN(-50;50). Formula A2:A500 -> =RANDBETWEEN(A1[RELATIVE]-25;A1[RELATIVE]+25). Formula B2:CW500 -> =IF(A2[RELATIVE]>B1[RELATIVE];RANDBETWEEN(B1[RELATIVE]-24;B1+26);RANDBETWEEN(B1-25;B1[RELATIVE]+25)) Blue Squares -> Values more than 100. Red Squares -> Values less than -100. Line Graph -> Average value across each row 1-500. |
