The Value Of Competition

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 One


Formula 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 Two


Formula 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.


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s