« Testing Word 2007 for blogging | Main | Microsoft Word - Move to the last change – what went wrong »

April 12, 2007

Variation - they mysteries of ...

If you are remotely interested in good management then fire up Excel and try the simulation below.  It took me about 5 minutes and I was astounded by the results .  Several manual recalcs later and I was even more suprised.

Here is a statistical intuition test from product development guru Donald Reinertsen, which he said is based on an example from "Introduction to Probability Theory and its Applications" by William Feller.

Suppose you flip a coin 1000 times. Keep a cumulative sum, starting with zero and then every time it comes up heads you get add 1, every time it comes up tails you subtract 1.

Question 1: How many times will the cumulative sum equal zero?
Question 2: How many flips will there be, on average, between the times the sum equals zero?

You can simulate this quite easily using a spreadsheet like Excel.

[Via my TOC friend, Steve Holt]

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00e5501159c3883400e54ffd1ed58833

Listed below are links to weblogs that reference Variation - they mysteries of ...:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Ok Clarke, I don't get it. What's the connection with good management?

Didn't you know all coins are biased.... You toss it once and it immediately has a bias because it is now always one up for that side of the coin ;-)

It also shows why most personnel assessments don't really work because they think they need a corrective action for a random event.

P.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment