ABCDEFGHIJKLMNOPQRSTU
1
2
Instructions: Alter the inputs in the yellow cells and drag down the rows formula below where needed
3
Race length (km)11 race
4
Tortoise time for 1 km (min)100Tortoise wins77.38%
5
Hare time for 1 km (min)20Hare wins22.62%
6
Nap interval (min)20
7
Hare chance to nap0.95100 races
8
Hare chance to be awake0.05Only tortoises win0.00%
9
Intervals required for hare to win1.0At least 1 hare wins100.00%
10
Intervals required for tortoise to win5.0
11
12
Intervals where hare is awakeFactorial formulaBinom formulaCumulative %Number of races
% chance at least one hare wins
13
077%77%77%123%
14
120%20%98%240%
15
22%2%100%354%
16
30%0%100%464%
17
40%0%100%572%
18
50%0%100%679%
19
783%
20
887%
21
990%
22
1092%
23
1194%
24
1295%
25
1396%
26
1497%
27
1598%
28
1698%
29
1799%
30
1899%
31
1999%
32
2099%
33
21100%
34
22100%
35
23100%
36
24100%
37
25100%
38
26100%
39
27100%
40
28100%
41
29100%
42
30100%
43
31100%
44
32100%
45
33100%
46
34100%
47
35100%
48
36100%
49
37100%
50
38100%
51
39100%
52
40100%
53
41100%
54
42100%
55
43100%
56
44100%
57
45100%
58
46100%
59
47100%
60
48100%
61
49100%
62
50100%
63
51100%
64
52100%
65
53100%
66
54100%
67
55100%
68
56100%
69
57100%
70
58100%
71
59100%
72
60100%
73
61100%
74
62100%
75
63100%
76
64100%
77
65100%
78
66100%
79
67100%
80
68100%
81
69100%
82
70100%
83
71100%
84
72100%
85
73100%
86
74100%
87
75100%
88
76100%
89
77100%
90
78100%
91
79100%
92
80100%
93
81100%
94
82100%
95
83100%
96
84100%
97
85100%
98
86100%
99
87100%
100
88100%