NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1060344
Record Type: Journal
Publication Date: 2010-Feb
Pages: 14
Abstractor: As Provided
ISSN: ISSN-1942-2504
A Spreadsheet Simulation of the Monty Hall Problem
Patterson, Mike C.; Harmel, Bob; Friesen, Dan
American Journal of Business Education, v3 n2 p1-13 Feb 2010
The "Monty Hall" problem or "Three Door" problem--where a person chooses one of three doors in hope of winning a valuable prize but is subsequently offered the choice of changing his or her selection--is a well known and often discussed probability problem. In this paper, the structure, history, and ultimate solution of the Monty Hall problem are discussed. The problem solution is modeled with a spreadsheet simulation that evaluates the frequencies of the possible outcomes (win or lose) under the two choices or strategies available: switch to the unopened door or do not switch. A Law of Large Numbers approach is also used to graphically demonstrate the long run outcome of adopting one the two available strategies. As is known, the optimal strategy is to switch to the unopened door; the spreadsheet model illustrates why this strategy is optimal. A complete discussion of the spreadsheet logic is included. Pedagogical approaches and applications of the spreadsheet simulation approach are also discussed.
Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A