I thought an interesting experiment would be to port the National Team Rankings over to club football and see what they come up with. So as a start, I gathered up all the league and FA Cup matches for the first five divisions in the English Pyramid the last four years. Promotion and Relegation provide us with the necessary sample sizes to do this, and the FA Cup matches help increase that sample as well. I’ll start by simpling posting the rankings:
Team | OFFRat | DEFRat | Rank | Division |
Manchester United | 14.87 | 354.88 | 1 | English Premiership |
Chelsea | 14.57 | 337.18 | 2 | English Premiership |
Liverpool | 12.21 | 298.97 | 3 | English Premiership |
Arsenal | 13.79 | 245.45 | 4 | English Premiership |
Everton | 10.37 | 231.96 | 5 | English Premiership |
Tottenham Hotspur | 11.52 | 184.85 | 6 | English Premiership |
Aston Villa | 10.66 | 195.70 | 7 | English Premiership |
Manchester City | 10.16 | 185.38 | 8 | English Premiership |
Newcastle United | 8.69 | 168.23 | 9 | English Premiership |
Blackburn Rovers | 8.45 | 168.70 | 10 | English Premiership |
Fulham | 7.35 | 185.16 | 11 | English Premiership |
Portsmouth | 7.58 | 179.57 | 12 | English Championship |
West Ham United | 7.88 | 168.00 | 13 | English Premiership |
West Bromwich Albion | 9.32 | 140.00 | 14 | English Premiership |
Sunderland | 7.61 | 163.82 | 15 | English Premiership |
Birmingham | 6.98 | 178.03 | 16 | English Premiership |
Bolton Wanderers | 7.84 | 158.54 | 17 | English Premiership |
Reading | 8.05 | 149.38 | 18 | English Championship |
Stoke City | 7.00 | 168.96 | 19 | English Premiership |
Middlesbrough | 6.81 | 168.11 | 20 | English Championship |
Sheffield United | 6.53 | 158.97 | 21 | English Championship |
Wigan Athletic | 6.75 | 153.08 | 22 | English Premiership |
Wolverhampton Wanderers | 6.97 | 148.19 | 23 | English Premiership |
Cardiff City | 7.07 | 139.29 | 24 | English Championship |
Hull City | 6.84 | 134.56 | 25 | English Championship |
Leicester City | 6.12 | 147.32 | 26 | English Championship |
Swansea City | 5.97 | 149.05 | 27 | English Championship |
Crystal Palace | 5.98 | 146.85 | 28 | English Championship |
Burnley | 7.10 | 122.22 | 29 | English Championship |
Ipswich Town | 6.42 | 134.18 | 30 | English Championship |
Nottingham Forest | 5.88 | 144.41 | 31 | English Championship |
Blackpool | 6.85 | 122.37 | 32 | English Premiership |
Preston North End | 6.60 | 126.42 | 33 | English Championship |
Watford | 6.88 | 117.23 | 34 | English Championship |
Bristol City | 5.84 | 133.12 | 35 | English Championship |
Southampton | 6.62 | 114.21 | 36 | English League One |
Leeds United | 5.99 | 125.83 | 37 | English Championship |
Norwich City | 6.51 | 114.32 | 38 | English Championship |
Charlton Athletic | 6.04 | 121.66 | 39 | English League One |
Queens Park Rangers | 5.75 | 127.35 | 40 | English Championship |
Sheffield Wednesday | 6.02 | 120.99 | 41 | English League One |
Doncaster Rovers | 5.23 | 136.03 | 42 | English Championship |
Plymouth Argyle | 5.51 | 127.42 | 43 | English League One |
Derby County | 5.87 | 114.98 | 44 | English Championship |
Coventry City | 5.33 | 121.26 | 45 | English Championship |
Scunthorpe United | 6.24 | 102.21 | 46 | English Championship |
Barnsley | 5.43 | 113.56 | 47 | English Championship |
Colchester United | 5.65 | 101.56 | 48 | English League One |
Millwall | 5.11 | 111.56 | 49 | English Championship |
Milton Keynes Dons | 5.52 | 101.18 | 50 | English League One |
Peterborough United | 5.64 | 98.18 | 51 | English League One |
Swindon Town | 5.20 | 97.83 | 52 | English League One |
Huddersfield Town | 5.37 | 92.55 | 53 | English League One |
Oldham Athletic | 4.59 | 103.47 | 54 | English League One |
Walsall | 4.55 | 102.37 | 55 | English League One |
Bristol Rovers | 4.83 | 95.04 | 56 | English League One |
Carlisle United | 4.84 | 94.51 | 57 | English League One |
Southend United | 4.90 | 90.86 | 58 | English League Two |
Tranmere Rovers | 4.30 | 103.26 | 59 | English League One |
Rochdale | 5.12 | 86.58 | 60 | English League One |
Brighton | 4.65 | 94.74 | 61 | English League One |
Hartlepool United | 5.09 | 84.51 | 62 | English League One |
Northampton Town | 4.49 | 94.02 | 63 | English League Two |
Bournemouth | 4.28 | 91.16 | 64 | English League One |
Notts County | 4.13 | 93.27 | 65 | English League One |
Wycombe Wanderers | 3.91 | 97.44 | 66 | English League Two |
Leyton Orient | 4.19 | 90.34 | 67 | English League One |
Luton Town | 4.35 | 86.13 | 68 | English Conference |
Yeovil Town | 3.79 | 97.13 | 69 | English League One |
Brentford | 4.04 | 90.62 | 70 | English League One |
Exeter City | 4.27 | 85.75 | 71 | English League One |
Dagenham & Redbridge | 4.75 | 76.78 | 72 | English League One |
Stevenage Borough | 4.28 | 81.22 | 73 | English League Two |
Chesterfield | 4.19 | 82.45 | 74 | English League Two |
Stockport County | 4.32 | 79.52 | 75 | English League Two |
Shrewsbury Town | 3.80 | 90.31 | 76 | English League Two |
Rotherham United | 4.01 | 84.55 | 77 | English League Two |
Crewe Alexandra | 4.60 | 72.78 | 78 | English League Two |
Gillingham | 3.94 | 84.95 | 79 | English League Two |
Oxford United | 3.53 | 94.36 | 80 | English League Two |
Bradford City | 4.11 | 80.20 | 81 | English League Two |
Bury | 3.75 | 86.68 | 82 | English League Two |
Torquay United | 3.98 | 80.47 | 83 | English League Two |
Hereford United | 3.73 | 85.69 | 84 | English League Two |
Morecambe | 4.04 | 76.86 | 85 | English League Two |
Port Vale | 3.85 | 77.69 | 86 | English League Two |
Burton Albion | 4.20 | 70.72 | 87 | English League Two |
Aldershot Town | 4.11 | 71.46 | 88 | English League Two |
Cambridge United | 3.62 | 80.22 | 89 | English Conference |
Rushden & Diamonds | 3.59 | 78.12 | 90 | English Conference |
Cheltenham Town | 3.78 | 73.69 | 91 | English League Two |
Darlington | 3.44 | 80.74 | 92 | English Conference |
Kettering Town | 2.94 | 94.10 | 93 | English Conference |
Lincoln City | 3.70 | 73.04 | 94 | English League Two |
AFC Wimbledon | 3.58 | 74.30 | 95 | English Conference |
Kidderminster Harriers | 3.44 | 75.97 | 96 | English Conference |
York City | 3.34 | 77.61 | 97 | English Conference |
Barnet | 3.62 | 71.03 | 98 | English League Two |
Mansfield Town | 3.57 | 68.63 | 99 | English Conference |
Accrington Stanley | 3.69 | 64.65 | 100 | English League Two |
Macclesfield Town | 3.29 | 71.32 | 101 | English League Two |
Grimsby Town | 3.43 | 68.29 | 102 | English Conference |
Crawley Town | 3.52 | 66.21 | 103 | English Conference |
Wrexham | 2.88 | 79.85 | 104 | English Conference |
Histon | 3.60 | 63.77 | 105 | English Conference |
Salisbury City | 3.38 | 61.41 | 106 | English Southern Premier League |
Chester City | 2.98 | 69.08 | 107 | Dissolved |
Forest Green Rovers | 3.67 | 55.57 | 108 | English Conference |
Boston Utd | 3.33 | 58.60 | 109 | English Conference North |
Southport | 3.29 | 58.88 | 110 | English Conference |
Halifax | 3.12 | 58.06 | 111 | Dissolved |
Ebbsfleet United | 3.12 | 57.88 | 112 | English Conference South |
Barrow | 2.99 | 58.61 | 113 | English Conference |
Tamworth | 2.41 | 72.26 | 114 | English Conference |
Altrincham | 2.91 | 59.86 | 115 | English Conference |
Woking | 2.53 | 64.56 | 116 | English Conference South |
Hayes & Yeading | 3.58 | 42.75 | 117 | English Conference |
Northwich Victoria | 2.91 | 51.85 | 118 | English Northern Premier League |
Gateshead | 2.82 | 52.37 | 119 | English Conference |
Grays Athletic | 2.54 | 58.01 | 120 | English Isthmian League Division One North |
Other | 2.91 | 50.16 | 121 | Various |
Eastbourne Borough | 2.76 | 52.08 | 122 | English Conference |
Weymouth | 2.79 | 48.59 | 123 | English Southern Premier League |
St. Albans | 3.03 | 43.77 | 124 | English Conference South |
Farsley Celtic | 2.51 | 46.09 | 125 | Dissolved |
Stafford Rangers | 2.44 | 44.45 | 126 | English Conference North |
Droylsden | 2.50 | 39.74 | 127 | English Conference North |
Lewes | 1.52 | 42.15 | 128 | English Conference South |
There’s lots to comment on here, but I’ll start by explaining a few things about the table. First off the rankings work the same way as the National Team rankings, however aren’t scaled the same way. IOW, you can’t take Turkey’s ranking from the National Team rankings and compare it to say Manchester City. Doesn’t work that way. These rankings are self contained. Also you may have noticed there’s a team called “Other” in the rankings. What I did is that I treated all teams from the FA Cup that did not play in the top five divisions in any of the last four years and treated them simply as a single team. It’s a shortcut that helps me keep the data while not relying on tiny sample sizes. The club’s more recent games are weighted more heavily than games three and four years ago, but you’d be surprised at how relevant results three and four years ago might still be. Finally the division listed is the division the club will be playing in this year.
Now onto the specifics. There is considerable cause for concern in using these ratings for prediction purposes. Unlike National Teams, the playing squads for club teams can fluctuate due to changes in budget and such. Wales always had Ryan Giggs, but when the budget crunch happens, teams like Portsmouth can lose all the players who compiled the results the system is using. So until I can further test how well it works, using this system as a prediction system is problematic at best. However as a system that tells you what has happened, I think it looks like it does a remarkably nice job. The clubs are nicely banded within their divisions, IE no League Two teams ahead of Premiership teams and stuff like that.
The real utility for a system like this would be for looking at the teams across Europe and handicapping which leagues are stronger than others and that will be the next thing I’ll post on this subject.
EDIT: Initially failed to credit my source for the data. A major boo-boo and I apologize.
Full credit to http://www.football-data.co.uk/ and ESPN for the source data.
7 responses so far ↓
1 Amir // Aug 10, 2010 at 11:30 am
Thanks, it would be great to bring back the European club rankings from 2005-2006 as well…
2 Voros // Aug 10, 2010 at 12:52 pm
Going to, but that involves a lot more work so it takes a bit.
3 Steve // Aug 13, 2010 at 3:18 am
An intriguing initial post. I fear for Blackpool in the Premier League with that DEFRat. Out of interest where did you gather the data on the games from? Is there some nice source I’ve missed?
4 Voros // Aug 14, 2010 at 12:40 pm
I got the majority of it from here:
http://www.football-data.co.uk/
And made a big boo-boo not crediting them. I meant too but got caught up in the meat of the post, my apologies.
ESPN has a good data set, and it’s not too hard to gather it all up if you know how. I used them to fill in the gaps (FA Cup and a few slices of data missing from above).
For the full Europe one, I’ll have to use other sources which means it will take some time.
5 Maciej // Aug 15, 2010 at 9:00 am
Hi Voros!
Thanks a lot for the analysis!
Speaking about how well a prediction system works. How do You measure it?
6 Stevan // Jan 11, 2011 at 10:05 am
Hi Voros,
the return would be even more triumphant if you would update your http://vorosmccracken.com/nationalteamrankings071010.html
How about End of January 2011/Beginning of February 2011?
Then the 2011 AFC Asian Cup is just over and the season begins with thrilling friendlies and the Nations Cup on February 8th.
And time enough to forecast the rebeginning UEFA Euro 2012 qualifying at March 25th!!
greetings and keep up the good work!
Stevan
7 Juan // Mar 23, 2011 at 4:53 pm
Is this blog officially dead? What can we do to bring you back Voros?
Leave a Comment