Activity 2 - Olympic medal data (Answers).xlsx

	A	B	C	D	E	F
1	Rank	Country	Gold	Silver	Bronze	Total
2	63	Algeria (ALG)	0	2	0	2
3	27	Argentina (ARG)	3	1	0	4
4	42	Armenia (ARM)	1	3	0	4
5	10	Australia (AUS)	8	11	10	29
6	78	Austria (AUT)	0	0	1	1
7	39	Azerbaijan (AZE)	1	7	10	18
8	51	Bahamas (BAH)	1	0	1	2
9	48	Bahrain (BRN)	1	1	0	2
10	40	Belarus (BLR)	1	4	4	9
11	35	Belgium (BEL)	2	2	2	6
12	13	Brazil (BRA)*	7	6	6	19
13	66	Bulgaria (BUL)	0	1	2	3
14	69	Burundi (BDI)	0	1	0	1
15	20	Canada (CAN)	4	3	15	22
16	3	China (CHN)	26	18	26	70
17	50	Chinese Taipei (TPE)	1	0	2	3
18	23	Colombia (COL)	3	2	3	8
19	17	Croatia (CRO)	5	3	2	10
20	18	Cuba (CUB)	5	2	4	11
21	43	Czech Republic (CZE)	1	2	7	10
22	28	Denmark (DEN)	2	6	7	15
23	78	Dominican Republic (DOM)	0	0	1	1
24	75	Egypt (EGY)	0	0	3	3
25	78	Estonia (EST)	0	0	1	1
26	44	Ethiopia (ETH)	1	2	5	8
27	54	Fiji (FIJ)	1	0	0	1
28	78	Finland (FIN)	0	0	1	1
29	7	France (FRA)	10	18	14	42
30	38	Georgia (GEO)	2	1	4	7
31	5	Germany (GER)	17	10	15	42
32	2	Great Britain (GBR)	27	23	17	67
33	26	Greece (GRE)	3	1	2	6
34	69	Grenada (GRN)	0	1	0	1
35	12	Hungary (HUN)	8	3	4	15
36	51	Independent Olympic Athletes (IOA)	1	0	1	2
37	67	India (IND)	0	1	1	2
38	46	Indonesia (INA)	1	2	0	3
39	25	Iran (IRI)	3	1	4	8
40	63	Ireland (IRL)	0	2	0	2
41	77	Israel (ISR)	0	0	2	2
42	9	Italy (ITA)	8	12	8	28
43	51	Ivory Coast (CIV)	1	0	1	2
44	16	Jamaica (JAM)	6	3	2	11
45	6	Japan (JPN)	12	8	21	41
46	54	Jordan (JOR)	1	0	0	1
47	22	Kazakhstan (KAZ)	3	5	10	18
48	15	Kenya (KEN)	6	6	1	13
49	54	Kosovo (KOS)	1	0	0	1
50	65	Lithuania (LTU)	0	1	3	4
51	60	Malaysia (MAS)	0	4	1	5
52	61	Mexico (MEX)	0	3	2	5
53	67	Mongolia (MGL)	0	1	1	2
54	78	Morocco (MAR)	0	0	1	1
55	11	Netherlands (NED)	8	7	4	19
56	19	New Zealand (NZL)	4	9	5	18
57	69	Niger (NIG)	0	1	0	1
58	78	Nigeria (NGR)	0	0	1	1
59	34	North Korea (PRK)	2	3	2	7
60	74	Norway (NOR)	0	0	4	4
61	69	Philippines (PHI)	0	1	0	1
62	33	Poland (POL)	2	3	6	11
63	78	Portugal (POR)	0	0	1	1
64	54	Puerto Rico (PUR)	1	0	0	1
65	69	Qatar (QAT)	0	1	0	1
66	47	Romania (ROU)	1	1	2	4
67	4	Russia (RUS)	19	17	20	56
68	32	Serbia (SRB)	2	4	2	8
69	54	Singapore (SIN)	1	0	0	1
70	37	Slovakia (SVK)	2	2	0	4
71	45	Slovenia (SLO)	1	2	1	4
72	30	South Africa (RSA)	2	6	2	10
73	8	South Korea (KOR)	9	3	9	21
74	14	Spain (ESP)	7	4	6	17
75	29	Sweden (SWE)	2	6	3	11
76	24	Switzerland (SUI)	3	2	2	7
77	54	Tajikistan (TJK)	1	0	0	1
78	35	Thailand (THA)	2	2	2	6
79	78	Trinidad and Tobago (TTO)	0	0	1	1
80	75	Tunisia (TUN)	0	0	3	3
81	41	Turkey (TUR)	1	3	4	8
82	31	Ukraine (UKR)	2	5	4	11
83	78	United Arab Emirates (UAE)	0	0	1	1
84	1	United States (USA)	46	37	38	121
85	21	Uzbekistan (UZB)	4	2	7	13
86	62	Venezuela (VEN)	0	2	1	3
87	48	Vietnam (VIE)	1	1	0	2
88
89
90
91
92
93
94
95
96
97
98
99
100