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.
Leave a Reply