FIFA - Dual-Gender (Men+Women) - Rankings / Cups / Statistics / Facts ...

You listed 37 countries. When there's a tie for 8th the next rank needs to be 10th, not 9th. The USA is first in the Women's Ranking and you typed second.

 

So people who think that the FIFA rankings are worthless, or biased toward Europe, or whatever else, must love this thread. So, anyway, the latest follow.

A couple of notes: first, the men's ranking is now published using decimal points, so teams which would appear to be tied are actually separated: Mongolia and Andorra both are officially listed at #201 with six points, actually would be #201 Mongolia (6.45) and #202 Andorra (5.58); while the women's listed don't have decimal points so teams must stay tied (Iran and Israel are at #59 with 1418 points).

Secondly, tied teams should actually "split the points," so in the women's ranking, both teams should be at position 59.5 (=(59 + 60) / 2), but I didn't do that; may incorporate that later.

The women's rankings list only 140 teams as officially ranked, with the rest not having enough games to get a real ranking, so the combined ranking stops at 140.

FIBA basketball does list a combined ranking, but since the men's and women's rankings use the same point system, the combined rankings are just the sum of the two: http://www.fiba.com/rankingcombined

men, 2016 Jan 7

women, 2015 Dec 18

rank	team	confed	m	w	net
1	Germany	UEFA	4	2	6
2	Brazil	CONMEBOL	6	7	13
3	England	UEFA	9	5	14
4	Spain	UEFA	3	14	17
5	Netherlands	UEFA	14	12	26
6	Italy	UEFA	15	13	28
6	France	UEFA	25	3	28
8	Belgium	UEFA	1	28	29
9	Switzerland	UEFA	12	20	32
10	Colombia	CONMEBOL	8	25	33
10	USA	CONCACAF	32	1	33
12	Argentina	CONMEBOL	2	35	37
12	Austria	UEFA	10	27	37
14	Sweden	UEFA	34	8	42
15	Chile	CONMEBOL	5	41	46
15	Russia	UEFA	24	22	46
17	Portugal	UEFA	7	40	47
18	Mexico	CONCACAF	23	26	49
19	Ukraine	UEFA	29	23	52
20	Wales	UEFA	17	36	53
21	Romania	UEFA	16	39	55
21	Iceland	UEFA	36	19	55
23	Denmark	UEFA	42	15	57
23	Japan	AFC	53	4	57
25	Czech Republic	UEFA	27	33	60
26	Hungary	UEFA	20	42	62
27	Republic of Ireland	UEFA	31	32	63
28	Norway	UEFA	54	10	64
29	Poland	UEFA	35	31	66
30	Ecuador	CONMEBOL	13	54	67
31	Finland	UEFA	44	24	68
31	Australia	AFC	59	9	68
33	Korea Republic	AFC	51	18	69
34	Costa Rica	CONCACAF	37	34	71
35	Slovakia	UEFA	26	46	72
36	Croatia	UEFA	18	55	73
36	Scotland	UEFA	52	21	73
38	Uruguay	CONMEBOL	11	70	81
39	Côte d'Ivoire	CAF	19	63	82
40	Ghana	CAF	33	50	83
41	Turkey	UEFA	21	63	84
42	Bosnia and Herzegovina	UEFA	22	65	87
43	Northern Ireland	UEFA	30	66	96
44	Paraguay	CONMEBOL	46	52	98
44	Trinidad and Tobago	CONCACAF	50	48	98
46	China PR	AFC	82	17	99
46	Canada	CONCACAF	88	11	99
48	Serbia	UEFA	56	45	101
49	Iran	AFC	43	59	102
50	Nigeria	CAF	66	37	103
51	Cameroon	CAF	57	47	104
52	Algeria	CAF	28	77	105
53	Peru	CONMEBOL	47	61	108
54	Greece	UEFA	41	68	109
55	Uzbekistan	AFC	73	43	116
56	Albania	UEFA	38	81	119
56	Belarus	UEFA	68	51	119
56	Korea DPR	AFC	113	6	119
59	Equatorial Guinea	CAF	69	53	122
60	Slovenia	UEFA	61	62	123
61	Jamaica	CONCACAF	55	72	127
62	Israel	UEFA	71	59	130
62	South Africa	CAF	74	56	130
64	Senegal	CAF	45	92	137
64	United Arab Emirates	AFC	64	73	137
66	Jordan	AFC	86	58	144
67	Egypt	CAF	58	87	145
68	Congo	CAF	48	99	147
68	Bulgaria	UEFA	72	75	147
68	Haiti	CONCACAF	79	68	147
71	Venezuela	CONMEBOL	83	66	149
72	Thailand	AFC	124	30	154
73	Morocco	CAF	76	79	155
74	Mali	CAF	63	100	163
75	Bolivia	CONMEBOL	70	96	166
76	New Zealand	OFC	151	16	167
77	Guatemala	CONCACAF	93	76	169
78	Estonia	UEFA	90	82	172
79	Vietnam	AFC	146	29	175
80	Montenegro	UEFA	85	94	179
81	Faroe Islands	UEFA	96	86	182
82	Zambia	CAF	67	121	188
83	Cyprus	UEFA	80	115	195
84	Gabon	CAF	77	119	196
85	El Salvador	CONCACAF	99	103	202
85	Myanmar	AFC	158	44	202
87	Kazakhstan	UEFA	132	71	203
88	Zimbabwe	CAF	108	98	206
88	Bahrain	AFC	122	84	206
90	Latvia	UEFA	102	105	207
91	Hong Kong	AFC	137	74	211
92	Nicaragua	CONCACAF	97	117	214
93	Philippines	AFC	135	80	215
94	Kyrgyzstan	AFC	107	112	219
95	India	AFC	163	57	220
95	Chinese Taipei	AFC	182	38	220
97	Lithuania	UEFA	127	95	222
98	Ethiopia	CAF	118	109	227
99	Antigua and Barbuda	CONCACAF	92	138	230
100	Palestine	AFC	131	101	232
100	Cuba	CONCACAF	136	96	232
102	Botswana	CAF	95	140	235
102	Georgia	UEFA	120	115	235
104	Kenya	CAF	101	136	237
105	Malawi	CAF	106	134	240
106	Guam	AFC	156	85	241
107	St. Kitts and Nevis	CONCACAF	119	127	246
108	Guyana	CONCACAF	161	89	250
109	Papua New Guinea	OFC	203	49	252
110	Aruba	CONCACAF	115	139	254
110	Tanzania	CAF	126	128	254
110	Namibia	CAF	134	120	254
110	Luxembourg	UEFA	142	112	254
114	FYR Macedonia	UEFA	138	118	256
115	Indonesia	AFC	180	77	257
116	Moldova	UEFA	154	105	259
117	Malaysia	AFC	171	90	261
118	Dominican Republic	CONCACAF	160	102	262
119	Lebanon	AFC	140	125	265
120	St. Lucia	CONCACAF	144	122	266
120	Laos	AFC	178	88	266
122	Swaziland	CAF	133	135	268
123	Malta	UEFA	162	107	269
123	Fiji	OFC	186	83	269
125	Cook Islands	OFC	167	104	271
126	New Caledonia	OFC	183	92	275
127	Samoa	OFC	167	111	278
128	Puerto Rico	CONCACAF	173	108	281
129	Bermuda	CONCACAF	159	126	285
130	Afghanistan	AFC	153	133	286
130	Maldives	AFC	157	129	286
132	Grenada	CONCACAF	164	131	295
132	Tonga	OFC	204	91	295
134	Bangladesh	AFC	179	123	302
135	Dominica	CONCACAF	176	132	308
136	Nepal	AFC	196	114	310
136	Solomon Islands	OFC	200	110	310
138	Sri Lanka	AFC	188	124	312
139	Pakistan	AFC	185	130	315
140	Bhutan	AFC	192	137	329

 

It's not your fault that the Men's and Women's Rankings have an unequal amount of teams, but by adding the rankings it means that hypothetical Country X, who is at the 75th percentile in the Men's Rankings and 25th percentile in the Women's Rankings, would be siginificantly different from hypothetical Country Y, who is at the 25th percentile in the Men's Rankings and 75th percentile in the Women's Rankings. Here is a way to make a more complicated comparison that could be done in a spreadsheet:

The Men's Rankings have 209 countries, and the sum of the numbers from 1 to 209 is 21,945. The Women's Rankings have 140 countries, and the sum of numbers from 1 to 140 in 9,870. Start by awarding 209 points for first in the Men's Ranking, 208 points for second, and so on where each country gets 210 - their ranking down to 1 point for 209th. Then award 140 points for first in the Women's Rankings, 139 points for second, and so on where each country gets 141 - their ranking down to 1 point for 140th. To make the Men's Rankings and the Women's Rankings contribute the same amount of points, multiple the Men's values by 9,870 and multiple the Women's values by 21,945. This will result in each ranking contributing 216,597,150 points, which I know is a large number. Since each country's product in each ranking must be a multiple of 5 (because any whole number multiplied by 9,870 or 21,945 will be a multiple of 5), you can divide all the numbers by 5 without getting decimals. If you'd rather work with decimals than large numbers, you can divide all the numbers by 100 or something. Using this formula and dividing the totals by 5, here are the Top 10 in your rankings in the order by rankings would have them in (note that my ranking could have different countries in the Top 10, but I'm not spending the time figuring that out):

Germany: 1,016,715
England: 993,678
Brazil: 990,822
France: 970,872
Spain: 966,021
Netherlands: 953,085
Italy: 946,722
Switzerland: 921,921
Belgium: 908,523
Colombia: 907,872

In case it wasn't obvious, in this ranking the highest score is the best. A country who was first in both rankings would get 1,027,026.

 

I think I see what you're saying. A team that is ranked in the men's but unranked in the women's should get the points from the men's ranking, with zero points for the women's, giving the #1 team in the ranking getting the most points.

Alternately, I could have kept the 39 unofficial ranked women's teams, giving them places #141 to #179. (This still leaves 30 teams that aren't in both lists, as the men's actually lists 209 teams.)

Another tweak is that I could take only the 140 (or 179) teams that are in both, and throwing the other teams out of the listing, so both the men's and women's are based on a 1-to-140 (or 1-to-179) scale.

Or consider all un-ranked women's team to have the next available number, either #141 or #180. (Again, the "split the points" rule would average these, so #141 to #209 would average to #175.)

The standard way to do this in statistics (summing multiple lists that have different scales) is to normalize the each list to a real number from 0.00 to 1.00 . (I think this is what you were trying to do, using multipliers instead of divisors, and you allude to this with "percentiles.")

 

Given that each list has more than 100 teams, three decimal places would be necessary to give each team a unique ranking for each gender. Another thing I thought of would be to calculate what percent of the total points for the countries combined that each country had. The sum of the points for all the countries is not provided by FIFA, but if you enter every country and their points into a spreadsheet, you can calculate the sum. To make the numbers larger, you could multiply by 100, so a country with 1% (0.01) of all the points would get a score of 1. You could do this separately for the Men's Rankings and Women's Rankings and add the two numbers up for each country. The problem with that is that since the Women's Ranking values are much closer together, adding the two numbers up would cause most of the variation to come from the Men's Ranking.