Monty Hall Simulation
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
randomizer for the first doordoor 1 (originally picked)door 2 (randomized)door 3reveal loser behind this doorswitch to this doorend resultSuccess rateWarning: The creator of this simulation could have easily tampered with the data farther down the page in order to generate a conclusion to his liking. DO NOT BLINDLY ACCEPT THIS DATA. Run this simulation yourself by clicking File and Make a Copy. Verify the formulas in the first row and then fill down to the remaining 9999 rows.
2
2goatcarpig32CAR!66.73%Please be patient while calculating. There are a lot of moving parts in this simulation.
3
3piggoatcar23CAR!
4
1cargoatpig23pig
# of tests
5
1carpiggoat23goat10000
6
2goatpigcar23CAR!
Unlike the traditional Monty Hall puzzle, this one involves a goat and a pig to demonstrate that you do not need to focus on two different losing prizes. The focus is on the car.
7
3piggoatcar23CAR!
8
1cargoatpig23pigColumn Legend
9
3pigcargoat32CAR!
Column A: Randomizer. We first need to place the items behind the doors. The first door is given a pig, goat, or car.
10
1cargoatpig23pigColumn B: The "prize" behind door 1. The puzzle presumes you pick door 1, so this is our initial choice.
11
1cargoatpig32goatColumn C: The "prize" behind door 2. It cannot be the same thing as what's behind door 1.
12
1cargoatpig23pigColumn D: The "prize" behind door 3. It is whatever is not behind the other two doors.
13
2goatcarpig32CAR!
Column E: The door being revealed. If the car is behind 2 or 3, then obviously the other door is revealed. If the car is behind 1, then it randomly chooses door 2 or 3.
14
3pigcargoat32CAR!Column F: This is the door the contestant switches to. It is dependent entirely on which door is revealed.
15
3piggoatcar23CAR!Column G: The result after switching to door 2 or 3.
16
3pigcargoat32CAR!Column H: The number of car results in column G divided by the number of trials (in H5).
17
3pigcargoat32CAR!
18
1cargoatpig23pig
19
2goatcarpig32CAR!
20
3pigcargoat32CAR!
21
1carpiggoat23goat
22
1cargoatpig32goat
23
1cargoatpig32goat
24
3pigcargoat32CAR!
25
3piggoatcar23CAR!
26
3pigcargoat32CAR!
27
2goatcarpig32CAR!
28
2goatpigcar23CAR!
29
2goatcarpig32CAR!
30
3piggoatcar23CAR!
31
2goatcarpig32CAR!
32
3piggoatcar23CAR!
33
2goatpigcar23CAR!
34
2goatcarpig32CAR!
35
3pigcargoat32CAR!
36
3piggoatcar23CAR!
37
1carpiggoat32pig
38
2goatcarpig32CAR!
39
3pigcargoat32CAR!
40
3piggoatcar23CAR!
41
2goatcarpig32CAR!
42
2goatpigcar23CAR!
43
1carpiggoat32pig
44
3pigcargoat32CAR!
45
2goatcarpig32CAR!
46
3pigcargoat32CAR!
47
3piggoatcar23CAR!
48
1cargoatpig32goat
49
3pigcargoat32CAR!
50
2goatcarpig32CAR!
51
2goatcarpig32CAR!
52
3piggoatcar23CAR!
53
2goatpigcar23CAR!
54
2goatcarpig32CAR!
55
1cargoatpig32goat
56
2goatpigcar23CAR!
57
1cargoatpig23pig
58
2goatcarpig32CAR!
59
1cargoatpig32goat
60
2goatpigcar23CAR!
61
3piggoatcar23CAR!
62
1cargoatpig32goat
63
3piggoatcar23CAR!
64
1cargoatpig32goat
65
3piggoatcar23CAR!
66
3pigcargoat32CAR!
67
3pigcargoat32CAR!
68
1carpiggoat23goat
69
1carpiggoat32pig
70
2goatcarpig32CAR!
71
2goatpigcar23CAR!
72
3pigcargoat32CAR!
73
3pigcargoat32CAR!
74
2goatpigcar23CAR!
75
1cargoatpig32goat
76
1cargoatpig32goat
77
3piggoatcar23CAR!
78
3pigcargoat32CAR!
79
3piggoatcar23CAR!
80
1carpiggoat23goat
81
3piggoatcar23CAR!
82
2goatpigcar23CAR!
83
2goatcarpig32CAR!
84
3pigcargoat32CAR!
85
2goatcarpig32CAR!
86
1carpiggoat23goat
87
2goatcarpig32CAR!
88
2goatcarpig32CAR!
89
1cargoatpig32goat
90
1carpiggoat32pig
91
2goatcarpig32CAR!
92
3pigcargoat32CAR!
93
2goatpigcar23CAR!
94
3pigcargoat32CAR!
95
3pigcargoat32CAR!
96
3piggoatcar23CAR!
97
3piggoatcar23CAR!
98
3pigcargoat32CAR!
99
2goatpigcar23CAR!
100
1cargoatpig23pig
Loading...
 
 
 
Sheet1
 
 
Main menu