Quote from TigerBalm:
Mike805, your Excel sheet seems to work only because RANDBETWEEN(-1, 1) results in 2 cases (-1 and 0) where C is still the "High", and only 1 case where R is a High (for 1), i.e., 2/3 = 66.6%.
If you change that to RANDBETWEEN(-2, 2), you get 60% because now, there are 3 cases (-2, -1, and 0) where C = "High".
I'm not sure I see the "very neat property" here? Can you please state the exact property of random walk / distribution / gambling, which you intended to demonstrate? Maybe you can modify the Excel sheet?
To your first point, No - you're not understanding the math... you jumped to an incorrect conclusion...
To your second point, you changed the initial variables, hence the probability will change.
Attached please find a modified sheet that may be clearer.
The link below will shed some light on this for you as well:
http://en.wikipedia.org/wiki/Secretary_problem
What we're looking at is a trivial case of the above problem.
If after this you still don't see the "neat property" then we'll give it another shot.

