Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Strongest Nation?


All-time great

Status: Offline
Posts: 6109
Date:
RE: Strongest Nation?


Spectator wrote:

 
Intrigued (and tired) I thought I'd do a comparable table for women, including top 5 and top 10 averages. You can see why some teams dominate Fed Cup - the US, Russian, Czech, German and French teams are all top 5 averages within the top 50. The surprise for me was the depth of Germany, China and Japan. Then again, in terms of depth, the USA top 15 would place second (51.3) in the top 10 list, and the top 20 (68.15) are just pipped to the post by the Russian top 10.

All that said, probably some mistakes in here ... done quickly.

21.4/37.1 USA
22.4/64.7 RUS
26.4/78.2 CZE
38.8/71.1 GER
47.4/127.3 FRA
51.6/137.6 ROM
62.4/171 SPAIN
72.2/98.7 CHINA
72.8/131.6 JAPAN
76/173.4 ITA
84/187.4 SUI
92.6/187.5 SLOVAKIA
100/204.9 BEL
103.2/217.9 UKR
113.4/215.9 GBR
130.8/240.2 NED
134/231.4 AUS
136/310.6 CRO
144/328.5 SERBIA
155/386.1 BLR
169/ NA POL
250/422.2 CAN
253.6 TAIWAN



-- Edited by Spectator on Thursday 12th of January 2017 04:38:56 PM


 Thanks Spectator - interestingly GB are nearly the same average top 10 rank for men and women and positioned in 14th for women v 13th for men, suggesting we are at around the same level internationally in both, perhaps not in line with how most of us would think? 



__________________
JonH


All-time great

Status: Offline
Posts: 6109
Date:

Switzerland may be 22nd on the list of men top ten averages compiled by ABB but they win on other factors it seems:

From the Hopman Cup website

  • The tournament saw three record night session attendances this week; 13,684 (Mon 2 Jan),13,785 (Wed 4 Jan) and 13,917 (Fri 6 Jan)
  • 41,386 people in total attended Switzerlands three sessions, the highest combined attendance for a nations group matches in the tournaments history
  • Friday 6 Januarys night session between Switzerland and France saw the events largest session attendance in the Hopman Cups 29 year history with 13,917 attendees packing into Perth Arena to watch Kristina Mladenovic and Richard Gasquetdefeat Belinda Bencic and Roger Federer

No surprises on who the attraction was. Will be missed when he goes and I hope he can go deep in Melbourne next week - ideally a RU finish to Andy's W would be nice smile

 



__________________
JonH


All-time great

Status: Offline
Posts: 5568
Date:

JonH wrote:
AliBlahBlah wrote:

Added Map & Table for Top 10 players from each country only.
Country requires minimum 10 ranked players to qualify; there are 43 such countries.
GB are 13th.

https://public.tableau.com/views/20170112ATPCountryStrengths/Top10PlayersPerCountry?:embed=y&:display_count=yes


 Hi - thanks ABB, this is great and took it a level I never could. I dont know if you have the time to update these every now and then, monthly maybe? My main interest was to see where we stood relative to others and as Paulisi says, we also see Serbia ranking above the GB. But more importantly to see if we progress either relatively or in terms of average rank over the year ahead.

I am also v interested now in seeing if France can pip Spain for top spot as it is v close!

PS Dan helps a little today , long may his Sydney run continue! 


OK, I've set it up so that it should get each new weeks ATP rankings data - luckily you can grab all the ATP from 1-2000+ in one load, unlike the WTA.

It will update each week, around about when  the new ATP rankings are published.
I've added a date filter, and you can use that on each sheet to scroll back and forwards through time as required. I've back-added in the 02/01/2017 data to show how it works. Use the little arrows or the slider to move the date on each sheet.
At the moment you can't see much change with only two data points, and not much ranking movement between them, but the pattern will emerge over time.
After a few more weeks, I can add in a thing that tracks each point over time, and let's you play it, sort of like a movie, but I need about 6-8 weeks of data before implementing that. This should best show relative progression.

I ditched the map - very pretty, but not very informative - and put in a simpler chart that better shows the ranking relationships, and will serve better for multiple date periods.
Here is the new file: https://public.tableau.com/views/20170112ATPCountryStrengthsv1_1/Top10PlayersPerCountry?:embed=y&:display_count=yes
The old links above will not work correctly now.

I could add in WTA and overall, but the WTA rankings site only displays 100 records per time, and I don't really want to do 13 pages of downloads every week. If someone knows where to get the all the WTA data from 1- ~1270 all on a single page, then I can do it.



__________________


All-time great

Status: Offline
Posts: 6109
Date:

AliBlahBlah wrote:
JonH wrote:
AliBlahBlah wrote:

Added Map & Table for Top 10 players from each country only.
Country requires minimum 10 ranked players to qualify; there are 43 such countries.
GB are 13th.

https://public.tableau.com/views/20170112ATPCountryStrengths/Top10PlayersPerCountry?:embed=y&:display_count=yes


 Hi - thanks ABB, this is great and took it a level I never could. I dont know if you have the time to update these every now and then, monthly maybe? My main interest was to see where we stood relative to others and as Paulisi says, we also see Serbia ranking above the GB. But more importantly to see if we progress either relatively or in terms of average rank over the year ahead.

I am also v interested now in seeing if France can pip Spain for top spot as it is v close!

PS Dan helps a little today , long may his Sydney run continue! 


OK, I've set it up so that it should get each new weeks ATP rankings data - luckily you can grab all the ATP from 1-2000+ in one load, unlike the WTA.

It will update each week, around about when  the new ATP rankings are published.
I've added a date filter, and you can use that on each sheet to scroll back and forwards through time as required. I've back-added in the 02/01/2017 data to show how it works. Use the little arrows or the slider to move the date on each sheet.
At the moment you can't see much change with only two data points, and not much ranking movement between them, but the pattern will emerge over time.
After a few more weeks, I can add in a thing that tracks each point over time, and let's you play it, sort of like a movie, but I need about 6-8 weeks of data before implementing that. This should best show relative progression.

I ditched the map - very pretty, but not very informative - and put in a simpler chart that better shows the ranking relationships, and will serve better for multiple date periods.
Here is the new file: https://public.tableau.com/views/20170112ATPCountryStrengthsv1_1/Top10PlayersPerCountry?:embed=y&:display_count=yes
The old links above will not work correctly now.

I could add in WTA and overall, but the WTA rankings site only displays 100 records per time, and I don't really want to do 13 pages of downloads every week. If someone knows where to get the all the WTA data from 1- ~1270 all on a single page, then I can do it.


 v impressed! Thanks for this, really helpful! 

 

Interestingly, shows Argentina and USA swapping places already and Serbia and Japan also, with GB improving 3 ranking places in first week. More probably this week?



__________________
JonH


All-time great

Status: Offline
Posts: 6109
Date:

AliBlahBlah wrote:
JonH wrote:
AliBlahBlah wrote:

Added Map & Table for Top 10 players from each country only.
Country requires minimum 10 ranked players to qualify; there are 43 such countries.
GB are 13th.

https://public.tableau.com/views/20170112ATPCountryStrengths/Top10PlayersPerCountry?:embed=y&:display_count=yes


 Hi - thanks ABB, this is great and took it a level I never could. I dont know if you have the time to update these every now and then, monthly maybe? My main interest was to see where we stood relative to others and as Paulisi says, we also see Serbia ranking above the GB. But more importantly to see if we progress either relatively or in terms of average rank over the year ahead.

I am also v interested now in seeing if France can pip Spain for top spot as it is v close!

PS Dan helps a little today , long may his Sydney run continue! 


OK, I've set it up so that it should get each new weeks ATP rankings data - luckily you can grab all the ATP from 1-2000+ in one load, unlike the WTA.

It will update each week, around about when  the new ATP rankings are published.
I've added a date filter, and you can use that on each sheet to scroll back and forwards through time as required. I've back-added in the 02/01/2017 data to show how it works. Use the little arrows or the slider to move the date on each sheet.
At the moment you can't see much change with only two data points, and not much ranking movement between them, but the pattern will emerge over time.
After a few more weeks, I can add in a thing that tracks each point over time, and let's you play it, sort of like a movie, but I need about 6-8 weeks of data before implementing that. This should best show relative progression.

I ditched the map - very pretty, but not very informative - and put in a simpler chart that better shows the ranking relationships, and will serve better for multiple date periods.
Here is the new file: https://public.tableau.com/views/20170112ATPCountryStrengthsv1_1/Top10PlayersPerCountry?:embed=y&:display_count=yes
The old links above will not work correctly now.

I could add in WTA and overall, but the WTA rankings site only displays 100 records per time, and I don't really want to do 13 pages of downloads every week. If someone knows where to get the all the WTA data from 1- ~1270 all on a single page, then I can do it.


 im not technical but can you use live rankings? 

 

http://live-tennis.eu/en/wta-live-ranking

 

 



__________________
JonH


All-time great

Status: Offline
Posts: 5568
Date:

JonH wrote:
[...]

 im not technical but can you use live rankings? 

 http://live-tennis.eu/en/wta-live-ranking


Sadly, they only do the top 700 for the WTA at the moment. However, I did find a way to add in the WTA data that should be low-maintenance.

Updated file: https://public.tableau.com/views/20170112ATPCountryStrengthsv1_1/WTARelativeCountryStrength?:embed=y&:display_count=yes

For the measure by the top 10 ranked players, GB are:
ATP:  #13WTA: #14
Though the overall GB strength on the WTA side is a lot lower relative to it's peers.

I'll do comparisons and the combined ranking if it's not going to be too complex; maybe show the weekly movements/differences.



__________________


All-time great

Status: Offline
Posts: 5679
Date:

21U25U26U
109.8 USA82.2 AUS61.4 ARG
200.2 RUS82.2 USA82.2 AUS
227.4 AUS108.4 ARG82.2 USA
271.2 FRA113.6 RUS113.6 RUS
282.2 ITA117.8 FRA117.8 FRA
297.4 KOR181 ESP142.2 GER
330.4 ESP183.8 CZE143.2 BEL
343.8 GER192.8 ITA156.2 CZE
347 JAP198.6 JAP165.2 ESP
526 ARG199.8 BEL170.8 JAP
536 GBR207.4 SRB174.2 ITA
562.6 CZE207.8 GER179.2 SRB
591.6 SRB272 KOR196.2 CAN
 618.2 CAN297.2 GBR209.2 GBR
 712.2 BEL318.4 BRA265.2 KOR
713.2 CRO394.4 CAN318.4 BRA
716.2 BRA492 CRO466.2 CRO

An exercise to get the brain working on a Saturday morning: top 5  ATP players in given age groups. If this had been done one week earlier, GB would have been at 390.6 (#10 ranking) in the U21s. Which goes to show how arbitrary the whole thing is. But some of the trends are interesting - and for us, encouraging.
  

 

 



-- Edited by Spectator on Saturday 14th of January 2017 10:39:26 AM

__________________


Tennis legend

Status: Offline
Posts: 39321
Date:

Very interesting, thanks for all the work folk.

I see that it is #9 Serbia and #12 Belgium that add to the above list to put us down to #13 in the men's average of their best 10 rankings ( which I think is a really good indicator, including nations' very best with some element of depth ).

Serbia and Belgium, hmm.

__________________


All-time great

Status: Offline
Posts: 5568
Date:

Interestingly, when using the Top 'x' method, the value for 'x' makes a very great difference.
I looked on the ATP at everything from Top 3 to Top 30 per country.
For almost all values of 'x' in that range, France would be top nation.
We choose 10 for roundness and ease, but really it's arbitrary as anything else, and just happens to be one - of two, for the 09/01/2017 data - where Spain actually shade the top spot.

I'll try to update the file in due course, but it means re-jigging the data, and I may not have time for a while.


__________________


All-time great

Status: Offline
Posts: 6109
Date:

AliBlahBlah wrote:

Interestingly, when using the Top 'x' method, the value for 'x' makes a very great difference.
I looked on the ATP at everything from Top 3 to Top 30 per country.
For almost all values of 'x' in that range, France would be top nation.
We choose 10 for roundness and ease, but really it's arbitrary as anything else, and just happens to be one - of two, for the 09/01/2017 data - where Spain actually shade the top spot.

I'll try to update the file in due course, but it means re-jigging the data, and I may not have time for a while.


 Thanks again, what you have done is a great job and real help - excellent! 

Having a look at the ATP v WTA data. One thing that struck me was that 5 countries in each have an Avg Ranking for top 10 below 100 and similarly 12 nations have an average rank below 200 in both tables. Which suggests that in both mens and womens the spread of strength across countries is fairly similar. Historically, my perception has always been that the men were spread more widely, so that surprised me a little.

 

BTW, ATP have the 16th Jan rankings out now, Sunday, presumably with AO starting tomorrow. I see GB average would improve to 211 from 215, be interesting to see how the others have changed.

 

 

 



__________________
JonH


All-time great

Status: Offline
Posts: 5568
Date:

JonH wrote:
[...]

BTW, ATP have the 16th Jan rankings out now, Sunday, presumably with AO starting tomorrow. I see GB average would improve to 211 from 215, be interesting to see how the others have changed.


Added data for ATP 16/01/2017: https://public.tableau.com/views/20170116ATPWTACountryStrengthsv2_1/ATPRelativeCountryStrengths?:embed=y&:display_count=yes
All ATP charts/tables update automatically when the data is added.

By the Top 10 metric, USA reclaim the number 3 spot from Argentina.

Also added a chart that shows performance per head of male population - Spain, Argentina, Australia and especially, Serbia, Belgium & the Czechs all excel


WTA data not yet available (well, except on a pdf which doesn't work for me.), will update tomorrow.



__________________


Challenger level

Status: Offline
Posts: 2442
Date:

Fascinating work, which I will follow with interest...

But I think that there would be a different way to do it, which would give a very different, and perhaps more accurate result...

which is to aggregate the total points of each nation's top 10 players. It seems a little absurd that if Andy wins the Oz Open, and increases his points lead to 3,500 or so over Nole, he doesn't contribute any improvement to a GB's average position. Whereas if say Liam wins his current 15k, he might go up 20 places, and knock the average down a couple of points.

But Andy winning the Oz Open counts for more towards GB being a stronger tennis nation than Liam winning a Futures, by about 2,000 to 18.

The top 5 or so French players have around the same points as Andy alone - and about the same chance, or less, between them of winning any Slam, Premier, etc than Andy does.



-- Edited by wimdledont on Friday 20th of January 2017 09:54:17 AM

__________________


Futures qualifying

Status: Offline
Posts: 1681
Date:

Why is 10 the magic number?

Another approach is to just take the top 3 (coincidentally GBR comes out quite a bit better that way)

... or maybe the top 100 - that should weed out some smaller countries, and encourage those with quantity (perhaps rather than - or in addition to - quality).

__________________


All-time great

Status: Offline
Posts: 5568
Date:

 

christ wrote:

Why is 10 the magic number?

Another approach is to just take the top 3 (coincidentally GBR comes out quite a bit better that way)

... or maybe the top 100 - that should weed out some smaller countries, and encourage those with quantity (perhaps rather than - or in addition to - quality).


Yes, I mentioned this above.
10 just happens to be one value for top 'x' players where Spain tops the rankings.
You can see that for most values of 'x' France are the strongest nation.
GBR Ranking for different number of players goes like this:
vZuxgmu.png
I have updated the charts to allow you to pick any number of players between 5 and 30 as the basis for the average ranking.
It will also track the position over time now, to make changes more identifiable
I looked at 3, but there is so much potential skew from countries with one very highly ranked player, which speaks more to the brilliance of the individual, rather than the tennis strength of the nation. By the time you get to 5 it is smoothed out much more meaningfully.

As to Wimbledont's point about ranking points, there is something there, but ranking points vary per tournament, and you can only accrue the points from the tournaments you can get into. This biases towards countries that hold more events, at higher levels - which is probably unavoidable, someone has to hold them.
To try and look at this, I've added another sheet, that plots the ranking positions of the top 'x' players that you set, for which ever countries that you select.
This shows the relative positions of, say the GB Top 17 versus the BEL and FRA, or whoever, top 17's.
Perhaps this new tab shows the gulf in strength between GB and it's peers most clearly: Relative Player Positions Per Ranking
See how far GB quickly lags behind other nations.
Also, try increasing the number of players to 30, and see how, eventually, we do catch up to and overtake Belgium again.
The General picture is true across the board.

Comparing that to the population chart further underlines the lack of depth.

I've only updated the ATP charts so far.

Here's the new link: https://public.tableau.com/views/20170120ATPWTACountryStrengthsv2_2/ATPCountryRankings?:embed=y&:display_count=yes



__________________


Futures qualifying

Status: Offline
Posts: 1677
Date:

Averaging ranking of the top N players doesn't seem a very realistic measure of strength as if you considered the top 2 players, a country with the No. 1 & No. 1000 would have the same average as a country with the No 500 & No. 501. Also, taking the top 'N' doesn't seem fair as having more ranked players should make a country stronger, even if its not by much when they are relatively weak.

How about a formula where each player is given a score that represents what you feel their ranking is worth in terms of 'strength contribution' as a percentage of the top ranked player's strength, such as:

score% = (scale ^ -rank) / (scale ^ -1) * 100%

Where:

rank = player rank
scale = number just over 1.0 you input based on how you weight ranks

With this formula, the #1 player will always score 100%

If scale = 1.01 then

rank #10 = 91%, #50 = 61%, #100 = 37%, #300 =5%

if you think the top players deserve more weighting, scale = 1.02

rank #10 = 83%, #50 = 56%, #100 = 14%, #300 =0.27%


Then rank the countries based on the sum of all their ranked player's scores.

edit:

A better formula is:

score% = (scale ^ -rank/slope) / (scale ^ -1/slope) * 100%

where scale & slope both contribute to specifying the shape of the curve by which strength contribution declines - higher scales makes things fall more sharply from No. 1, and higher slopes make things tail off more slowly.
e.g. scale = 3, slope = 125 gives
#10 = 93%, #50 = 65%, #100=42%, #300=7%, #500 = 1%

-- Edited by RBBOT on Friday 20th of January 2017 08:43:42 PM

__________________
« First  <  Page 41  >   Last »  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard