swarm_chart_jitter.xlsx

	A	B	C	D	F	G	H	I	J	K	L	U	V	W	X	Y
1	Olympic Games Records: analysis of UK won gold medals
2	https://en.wikipedia.org/wiki/Great_Britain_at_the_Olympics
3	How to make a jitter plot in excel (youtube.com)
4
5	Summer Games		Year	Gold		X	Y	Total Count	Running Count	Space	Y	Athletes	Silver	Bronze	Total	Rank
6	Kingdom of Greece 1896 Athens	1	1896	2	1	1896	1	2	1	27	30	8	3	2	7	5
7	France 1900 Paris	3	1900	15	2	1896	1	2	2	27	31	103	8	9	32	3
8	United States 1904 St. Louis	18	1904	1	3	1900	1	15	1	20.5	23.5	3	1	0	2	9
9	United Kingdom 1908 London	19	1908	56	4	1900	1	15	2	20.5	24.5	676	51	39	146	1
10	Sweden 1912 Stockholm	75	1912	10	5	1900	1	15	3	20.5	25.5	293	15	16	41	3
11	Belgium 1920 Antwerp	85	1920	14	6	1900	1	15	4	20.5	26.5	204	15	13	42	3
12	France 1924 Paris	99	1924	9	7	1900	1	15	5	20.5	27.5	307	13	12	34	4
13	Netherlands 1928 Amsterdam	108	1928	3	8	1900	1	15	6	20.5	28.5	234	10	7	20	11
14	United States 1932 Los Angeles	111	1932	4	9	1900	1	15	7	20.5	29.5	74	7	5	16	8
15	Nazi Germany 1936 Berlin	115	1936	4	10	1900	1	15	8	20.5	30.5	225	7	3	14	10
16	United Kingdom 1948 London	119	1948	3	11	1900	1	15	9	20.5	31.5	375	14	6	23	12
17	Finland 1952 Helsinki	122	1952	1	12	1900	1	15	10	20.5	32.5	293	2	8	11	18
18	Australia 1956 Melbourne	123	1956	6	13	1900	1	15	11	20.5	33.5	200	7	11	24	8
19	Italy 1960 Rome	129	1960	2	14	1900	1	15	12	20.5	34.5	252	6	12	20	12
20	Japan 1964 Tokyo	131	1964	4	15	1900	1	15	13	20.5	35.5	199	12	2	18	10
21	Mexico 1968 Mexico City	135	1968	5	16	1900	1	15	14	20.5	36.5	237	5	3	13	10
22	West Germany 1972 Munich	140	1972	4	17	1900	1	15	15	20.5	37.5	310	5	9	18	12
23	Canada 1976 Montreal	144	1976	3	18	1904	1	1	1	27.5	30.5	234	5	5	13	13
24	Soviet Union 1980 Moscow	147	1980	5	19	1908	1	56	1	0	3	222	7	9	21	9
25	United States 1984 Los Angeles	152	1984	5	20	1908	1	56	2	0	4	355	11	21	37	11
26	South Korea 1988 Seoul	157	1988	5	21	1908	1	56	3	0	5	382	10	9	24	12
27	Spain 1992 Barcelona	162	1992	5	22	1908	1	56	4	0	6	389	3	12	20	13
28	United States 1996 Atlanta	167	1996	1	23	1908	1	56	5	0	7	303	8	6	15	36
29	Australia 2000 Sydney	168	2000	11	24	1908	1	56	6	0	8	310	10	7	28	10
30	Greece 2004 Athens	179	2004	9	25	1908	1	56	7	0	9	270	9	12	30	10
31	China 2008 Beijing	188	2008	19	26	1908	1	56	8	0	10	313	13	19	51	4
32	United Kingdom 2012 London	207	2012	29	27	1908	1	56	9	0	11	541	18	18	65	3
33	Brazil 2016 Rio de Janeiro	236	2016	27	28	1908	1	56	10	0	12	366	23	17	67	2
34	Japan 2020 Tokyo	263	2020	22	29	1908	1	56	11	0	13	376	20	22	64	4
35		285			30	1908	1	56	12	0	14
36					31	1908	1	56	13	0	15	Athletes	Silver	Bronze	Total	Rank
37					32	1908	1	56	14	0	16	45	1	2	4	6
38	Winter Games			Gold	33	1908	1	56	15	0	17	33	0	1	1	8
39	France 1924 Chamonix			1	34	1908	1	56	16	0	18	4	0	0	0	–
40	Switzerland 1928 St. Moritz			0	35	1908	1	56	17	0	19	39	1	1	3	7
41	United States 1932 Lake Placid			0	36	1908	1	56	18	0	20	55	0	2	2	13
42	Nazi Germany 1936 Garmisch-Partenkirchen			1	37	1908	1	56	19	0	21	20	0	0	1	8
43	Switzerland 1948 St. Moritz			0	38	1908	1	56	20	0	22	45	0	0	0	–
44	Norway 1952 Oslo			1	39	1908	1	56	21	0	23	17	0	0	0	–
45	Italy 1956 Cortina d'Ampezzo			0	40	1908	1	56	22	0	24	49	0	0	1	11
46	United States 1960 Squaw Valley			0	41	1908	1	56	23	0	25	46	0	0	0	–
47	Austria 1964 Innsbruck			1	42	1908	1	56	24	0	26	40	0	0	0	–
48	France 1968 Grenoble			0	43	1908	1	56	25	0	27	50	0	0	1	12
49	Japan 1972 Sapporo			0	44	1908	1	56	26	0	28	50	0	0	1	11
50	Austria 1976 Innsbruck			1	45	1908	1	56	27	0	29	54	0	0	1	11
51	United States 1980 Lake Placid			1	46	1908	1	56	28	0	30	57	0	0	0	–
52	Socialist Federal Republic of Yugoslavia 1984 Sarajevo			1	47	1908	1	56	29	0	31	54	0	0	0	–
53	Canada 1988 Calgary			0	48	1908	1	56	30	0	32	35	0	2	2	21
54	France 1992 Albertville			0	49	1908	1	56	31	0	33	33	0	1	1	22
55	Norway 1994 Lillehammer			0	50	1908	1	56	32	0	34	51	0	1	2	18
56	Japan 1998 Nagano			0	51	1908	1	56	33	0	35	40	1	0	1	21
57	United States 2002 Salt Lake City			1	52	1908	1	56	34	0	36	50	0	0	1	19
58	Italy 2006 Turin			0	53	1908	1	56	35	0	37	56	1	3	5	19
59	Canada 2010 Vancouver			1	54	1908	1	56	36	0	38	58	0	4	5	19
60	Russia 2014 Sochi			1	55	1908	1	56	37	0	39	50	1	0	2	19
61	South Korea 2018 Pyeongchang			1	56	1908	1	56	38	0	40	future event
62	China 2022 Beijing			1	57	1908	1	56	39	0	41
63					58	1908	1	56	40	0	42
64					59	1908	1	56	41	0	43
65					60	1908	1	56	42	0	44
66					61	1908	1	56	43	0	45
67					62	1908	1	56	44	0	46
68					63	1908	1	56	45	0	47
69					64	1908	1	56	46	0	48
70					65	1908	1	56	47	0	49
71					66	1908	1	56	48	0	50
72					67	1908	1	56	49	0	51
73					68	1908	1	56	50	0	52
74					69	1908	1	56	51	0	53
75					70	1908	1	56	52	0	54
76					71	1908	1	56	53	0	55
77					72	1908	1	56	54	0	56
78					73	1908	1	56	55	0	57
79					74	1908	1	56	56	0	58
80					75	1912	1	10	1	23	26
81					76	1912	1	10	2	23	27
82					77	1912	1	10	3	23	28
83					78	1912	1	10	4	23	29
84					79	1912	1	10	5	23	30
85					80	1912	1	10	6	23	31
86					81	1912	1	10	7	23	32
87					82	1912	1	10	8	23	33
88					83	1912	1	10	9	23	34
89					84	1912	1	10	10	23	35
90					85	1920	1	14	1	21	24
91					86	1920	1	14	2	21	25
92					87	1920	1	14	3	21	26
93					88	1920	1	14	4	21	27
94					89	1920	1	14	5	21	28
95					90	1920	1	14	6	21	29
96					91	1920	1	14	7	21	30
97					92	1920	1	14	8	21	31
98					93	1920	1	14	9	21	32
99					94	1920	1	14	10	21	33
100					95	1920	1	14	11	21	34