Making the Best Choice II
Andy provides a workbook that attempts to solve the problem presented here. I don’t know if the logic is right, but the workbook is cool, and worth a look.
Download Andy’s Best Choice
Daily posts of Excel tips…and other stuff
Andy provides a workbook that attempts to solve the problem presented here. I don’t know if the logic is right, but the workbook is cool, and worth a look.
Download Andy’s Best Choice
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
J-Walk:
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 June 2004, 6:32 pmJohn:
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.
John
3 June 2004, 5:35 amAndy Miller:
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.
5 August 2004, 11:02 amAndreas:
Can’t make this work… Using Excel 2003 US
28 September 2004, 3:06 pmAndreas:
Stupid me… just installed 2003 and forgot the analysis toolpack… My bad
Cool program! - and site!!
28 September 2004, 3:17 pm