5 thoughts on “Making the Best Choice II

  1. If that file doesn’t seem to be working for you, make sure that the Analysis ToolPak add-in is installed. It uses the RANDBETWEEN function, which is provided by the ATP.

  2. I just tried this, and ran one iteration. Both Paulos and Colley chose the last envelope for $54, yet it called Paulos the winner.

    I saved the screen shot if anyone would like to see it.


  3. Thank you, J-Walk, for the tip. I use ATP so often that I almost forget that anyone does not use it.

    John, I’m a little confused about how that could happen. The formula for the Winner is =IF(C14=D14,”Tie”,IF(C14>D14,”Colley”,”Paulos”)). I’ll have to look into it, but it seems like a tough thing to reproduce.

  4. Stupid me… just installed 2003 and forgot the analysis toolpack… My bad

    Cool program! – and site!!

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.