Friday, 19 December 2014

The Enlightened Era: 2009 - 2016

Lots of numbers in this chart below.


  • Shots For per game
  • Shots Against per game
  • Shot Share or TSR
  • Shots On Target For per game
  • Shots On Target Against per game
  • Shots On Target Ratio
  • Goals For
  • Goals Against
  • Goal +/-
  • Goal%
  • Scoring%
  • Save%
  • PDO


Points Of Interest

  • Chelsea in 2009/10 were the best shots team of the enlightened era and it doesn't feel like a team will top their dominance for a while.
  • TSR and SoTR are pretty good indicators of team strength. 4 of the 5 title winners are in the top 10 all time (2009-2014) in SoTR. 9 of the bottom 20 in TSR were relegated, the others came close.
  • Wigan stayed up with a 81 PDO. I kinda think it must be a bug but I can't find one. Wigan posted a 50% SoTR and a 50% TSR that season and had a -42 goal difference. Somehow they survived.
  • Manchester United, the champions in 2012/13, posted a 53.4% TSR, which has confused many an analyst over the years.. That same year Manchester United posted a 59% SoTR which is the 22nd best on record. 66% of the goals scored on 59% of the shots on target.
  • Fulham, Cardiff and Norwich posted 3 of the bottom 6 Shots On Target ratios on record. Brutal teams.
  • Tottenham in 2012/13 are kinda crazy. Go seek out their numbers.
I will add more items of interest as I find 'em.

Thursday, 18 December 2014

Where Have All The Set Piece Goals Gone?

You have to sing the title of this post to to the tune of this bizarre classic by Paula Cole:


    

Killer chorus.

A question: Where have all the set piece goals gone?

Through 160 games this season we have seen 72 set piece goals (if the numbers are out lemme know). Through 160 games of the 13/14 season we had already seen 96 goals.

So what gives: are teams taking less set piece shots or has shooting% from set piece shots dropped off? In fact, both of these things have happened.

Set Piece Data In 14/15


S 14/15 SP Shots F SP Shots A SP Goals F SP Goals A Shooting%
Arsenal 56 38 3 6 5.4
Aston Villa 39 52 2 5 5.1
Burnley 39 67 1 6 2.6
Chelsea 54 31 7 2 13.0
Crystal Palace 41 58 6 7 14.6
Everton 41 47 6 2 14.6
Hull 28 65 2 2 7.1
Leicester 37 78 1 6 2.7
Liverpool 52 44 2 6 3.8
Man City 46 45 1 2.2
Man United 51 53 6 4 11.8
Newcastle 62 44 2 2 3.2
QPR 66 53 5 4 7.6
Southampton 52 42 3 1 5.8
Stoke 63 60 2 4 3.2
Sunderland 57 31 3 1 5.3
Swansea 33 52 1 4 3.0
Tottenham 52 43 5 1 9.6
West Brom 48 46 5 5 10.4
West Ham 72 40 9 4 12.5
Total 989 989 72 72 7.3

72 goals on 989 shots for a shooting% of 7.3% from set pieces.

Set Piece Data In 13/14


S 13/14 SP Shots F SP SHots A SP Goals F SP Goals A Shooting%
Arsenal 41 50 4 4 9.8
Aston Villa 39 50 3 4 7.7
Cardiff 59 67 5 2 8.5
Chelsea 57 42 7 5 12.3
Palace 55 41 4 6 7.3
Everton 56 43 8 3 14.3
Fulham 38 75 6 8 15.8
Hull 57 64 2 4 3.5
Liverpool 61 47 10 5 16.4
Man City 65 28 10 5 15.4
Man United 51 44 6 6 11.8
Newcastle 46 57 4 6 8.7
Norwich 48 60 2 5 4.2
Southampton 68 50 5 3 7.4
Stoke 42 62 3 8 7.1
Sunderland 52 50 5 6 9.6
Swansea 39 57 4 3 10.3
Tottenham 64 54 3 2 4.7
West Brom 48 43 4 4 8.3
West Ham 55 57 1 7 1.8
1041 1041 96 96 9.2

96 goals on 1041 shots for a 9.2% shooting%.

We should know by know that shooting% fluctuates over small samples and a drop from 9.2% to 7.3% can probably be filed under 'shit happens'. The shooting% may well regress so let's not worry too much about percentages. But I do wonder why shots from set pieces are down by 152 from this point last year, -152 shots is almost a shot per game.

Anyone have any ideas? Data issues; a change in tactics; fewer shots from corners; fewer direct free kicks being given; better defending from set piece situations?

As always I want you guys to do some of the work, so let me in the comments if you can think of any reasons for the drop off in both shots and shooting% from set pieces.




Wednesday, 17 December 2014

The Most One-Sided Game In Premier League History

By one-sided game I mean one-sided shots count. And I am just guessing at the IN PREMIER LEAGUE HISTORY bit, although Manchester City's title winning game, where the home side outshot QPR 44-3, is likely to be the most one side game on record.

Manchester City took a shot against QPR's goal every 131 seconds during this game. The then soon-to-be-champions were shooting at a ferocious pace in this game and as the chart below illustrates score effects and the sheer urgency of the situation led to ever more frequent shooting from the home side.

The second half of the game on that title-winning day saw Manchester City take a shot every 90 seconds. Staggering stuff. It very nearly ended in tragicomic farce but for that goal




Full Size Chart (LINK)


That Goal


Monday, 15 December 2014

Height & Weight Of Premier League Footballers (2014/15)

I don't really need to explain this too much.

I have taken the height and weight of every player to have played in the league (as of November the 12th, so a few players will be missing). I then split those players into three buckets: Defenders, Midfielders and Forwards. Goalkeepers are removed from this data.

This table lists the average height (cm) and weight (k) of each bucket of positional players for each and every Premier League team.

Table

As always, I publish the data for everyone to use, sort or scrape.



Ave Height (m) Ave Weight (k) D Height (m) D Weight (k) M Height (m) M Weight (m) F Height (m) F Weight (k)
Arsenal 180.6 72.4 182.5 74.9 176.6 67.1 182.7 75.2
Aston Villa 181.6 74.4 186 78.6 177.1 68.4 179.5 75.5
Burnley 180.6 74.5 182.1 75.1 177.7 72.3 181.7 75.8
Chelsea 183.6 79.9 186.8 85.2 183.2 75.6 181.1 78.4
Crystal Palace 180.9 74.2 186.9 78.9 176.3 68 179.8 75.5
Everton 180 75.4 180.4 75.2 179.9 75.5 179.6 75.4
Hull City 181.1 74 183.1 74.9 178.1 71.5 182.8 76.4
Leicester 181 75.2 181.7 78.7 178 74.2 182.4 73.3
Lge Ave 181.5 75.1 184 77.2 179.2 72.6 181.1 74.8
Liverpool 180.5 74.7 182.6 76.1 177.4 73 181.3 74.7
Man City 180.4 75.6 182 76.1 178.1 74.3 183 77.7
Man United 180.4 72.9 183.3 75.9 178.5 70.5 179.7 72.9
Newcastle 181.1 73.2 181.1 74.8 177.8 73 181 71.9
QPR 183.6 78.1 185.9 77.4 181.4 76.5 183.5 81.3
Southampton 181.8 75.7 183.7 78.4 179.8 72.2 181.4 76
Stoke 183.4 75.8 185.5 78.3 183.5 76.3 181.4 73.3
Sunderland 182.7 75.3 186 76.5 180 72.7 182.4 77.4
Swansea 180.6 74.2 183.6 76.3 183 75 174.2 70.6
Tottenham 181.9 74.8 182.9 75.6 182 74.3 180.6 74.3
West Brom 181.5 75 184.8 77.9 176.8 69.7 181.7 76.5
West Ham 182.8 76.4 184.6 77.9 182 75.3 182 76.3


A fun little graph to finish things off. Guess who the 75 kilo outlier is?



Sunday, 14 December 2014

Nationality Of Premier League Footballers (2014/15)

This is a pretty straightforward post really. The only rule I put in place in terms of eligibility was had a player actually played in the Premier League this season (14/15). Some guys have been injured all season, some guys just haven't played yet. Tough luck.

54 nationalities, 463 players.

42.1% are from the UK. 48.1% are from the UK & Ireland. 77.5% are from Europe.


Interactive Map

Map is fully interactive.



Full Screen Version (LINK)


Nationality By Team

Table is sortable by nationality and by team.


Arsenal Aston Villa Burnley Chelsea Crystal Palace Everton Hull City Leicester Liverpool Man City Man United Newcastle Queens Park Rangers Southampton Stoke Sunderland Swansea Tottenham West Brom West Ham
Algeria 1 1
Argentina 1 1 2 4 2 1 2 2 1 2 2 1
Australia 1 1 1 1
Austria 1 1
Belgium 1 2 2 1 1 2 2 1 3 1
Benin 1
Bosnia 1 1 1
Brazil 4 2 2 2 1 1
Cameroon 1 1
Canada 1
Chile 1 2
Colombia 1 1 1 1
Congo 1
Costa Rica 1 1 1
Ivory Coast 1 1 1 1 1
Croatia 1 1 2
Czech Republic 1 1
Denmark 1 1 1
Ecuador 1
Egypt 1 1
France 5 1 2 1 1 1 1 4 6 1 1 2 1 4 1
Germany 3 1 1 1 1 1
Ghana 1
Greece 1
Iceland 1
Ireland 2 3 2 4 5 1 1 1 2 1 4 1 1
Italy 2 1 2
Jamaica 1 1 1
Japan 1
Kenya 1
Mexico 1
Montenegro 1
Morocco 1 1 1 1
Netherlands 2 2 4 1 1 1 2
Nigeria 1 2 2
Norway 1
Paraguay 1
Poland 1 1 1
Portugal 1 1 1 1
Romania 1 1 1
Senegal 1 2 1 1 1 3
Serbia 2 1 2 1
Sierra Leone 1
Slovakia 1
South Africa 1
South Korea 1 1
Spain 4 3 3 3 3 1 2 1 2 1 1
Sweden 1 1 1
Switzerland 1 1
Togo 1
United Kingdom 7 10 16 2 16 9 13 13 8 3 13 8 11 10 5 9 9 9 12 12
United States 1 1 1 1
Uruguay 2 1 1
Zambia 1

If any readers spot any errors or over/under counting please let me know.

Wednesday, 10 December 2014

UEFA Youth League Numbers

A quick post here on some of the underlying numbers posted in the UEFA Youth League groups stages.

It is worth considering the relative quality of each group and the yawning gap in talent between some of these teams. Shots on target numbers are way up and I don't think it has anything to do with the data. Young teams just tend to give up shots on target at a higher rate (here's looking at you Eredivisie). The better teams will be able to take high quality shots on net at this level due to the skill disparity between the teams. Scoring and save percentages may remain high due to this skill disparity. Plus, you know, 6 games only and all that.



Visualization




The Table



Qualified W/R Group Club Goals For Goals Against Shots For Shots Against SoT For SoT Against Points Goal% Corsi SoTR SoT For % SoT Prev% SoT Rating Sh% Save% PDO Club
R D Anderlecht 14 8 13.3 8.5 7.3 4.2 13 63.6 61.1 63.8 55.0 51.0 106.0 31.8 68.0 99.8 Anderlecht
F APOEL 3 19 4.7 20.7 1.8 10.2 1 13.6 18.4 15.3 39.3 50.8 90.1 27.3 68.9 96.1 APOEL
W D Arsenal 15 8 12.7 13.8 5.5 5.0 9 65.2 47.8 52.4 43.4 63.9 107.3 45.5 73.3 118.8 Arsenal
C AS Monaco 7 12 14.0 11.0 5.2 4.5 6 36.8 56.0 53.4 36.9 59.1 96.0 22.6 55.6 78.1 AS Monaco
R E AS Roma 9 10 13.5 10.8 6.7 5.8 9 47.4 55.5 53.3 49.4 46.2 95.5 22.5 71.4 93.9 AS Roma
W A Atletico Madrid 12 6 15.3 10.8 6.2 4.2 15 66.7 58.6 59.7 40.2 61.5 101.8 32.4 76.0 108.4 Atletico Madrid
H Athelitic Bilbao 9 12 20.7 10.7 8.7 4.7 9 42.9 66.0 65.0 41.9 56.3 98.2 17.3 57.1 74.5 Athelitic Bilbao
W F Ajax 19 7 18.3 14.2 9.7 6.2 14 73.1 56.4 61.1 52.7 56.5 109.2 32.8 81.1 113.8 Ajax
B Basel 17 9 13.8 12.2 6.5 4.7 12 65.4 53.2 58.2 47.0 61.6 108.6 43.6 67.9 111.4 Basel
H BATE 2 13 6.7 21.5 2.7 8.7 1 13.3 23.7 23.5 40.0 59.7 99.7 12.5 75.0 87.5 BATE
R F Barcelona 10 7 14.0 11.3 6.0 6.0 9 58.8 55.3 50.0 42.9 47.1 89.9 27.8 80.6 108.3 Barcelona
C Bayer Leverkusen 12 14 12.2 14.5 6.0 6.3 6 46.2 45.6 48.6 49.3 56.3 105.6 33.3 63.2 96.5 Bayer Leverkusen
E Bayern Munich 5 16 12.5 10.7 6.3 6.0 3 23.8 54.0 51.4 50.7 43.8 94.4 13.2 55.6 68.7 Bayern Munich
W C Benfica 12 8 10.8 16.7 4.0 5.3 13 60.0 39.4 42.9 36.9 68.0 104.9 50.0 75.0 125.0 Benfica
D Borissia Dortmund 8 14 12.5 12.2 5.3 7.0 4 36.4 50.7 43.2 42.7 42.5 85.1 25.0 66.7 91.7 Borissia Dortmund
W G Chelsea 24 3 14.8 6.0 8.7 2.0 15 88.9 71.2 81.3 58.4 66.7 125.1 46.2 75.0 121.2 Chelsea
E CSKA 6 12 4.7 14.0 2.7 7.2 3 33.3 25.0 27.1 57.1 48.8 106.0 37.5 72.1 109.6 CSKA
D Galatasaray 10 17 11.3 15.3 5.5 7.5 6 37.0 42.5 42.3 48.5 51.1 99.6 30.3 62.2 92.5 Galatasaray
A Juventus 5 10 12.2 15.2 4.7 6.2 5 33.3 44.5 43.1 38.4 59.3 97.7 17.9 73.0 90.8 Juventus
R B Liverpool 16 9 13.8 10.7 6.7 3.8 12 64.0 56.5 63.5 48.2 64.1 112.3 40.0 60.9 100.9 Liverpool
B Ludogorets 27 4.0 16.3 1.2 7.8 0.0 19.7 13.0 29.2 52.0 81.2 0.0 42.6 42.6 Ludogorets
A Malmo 5 14 10.3 19.2 4.5 8.0 1 26.3 35.0 36.0 43.5 58.3 101.8 18.5 70.8 89.4 Malmo
W E Man City 22 4 14.7 9.8 8.0 4.7 18 84.6 59.9 63.2 54.5 52.5 107.1 45.8 85.7 131.5 Man City
G Maribor 4 25 5.5 18.7 2.0 9.5 13.8 22.8 17.4 36.4 49.1 85.5 33.3 56.1 89.5 Maribor
R A Olympiacos 12 4 15.3 7.8 6.5 4.2 13 75.0 66.2 60.9 42.4 46.8 89.2 30.8 84.0 114.8 Olympiacos
F PSG 14 13 19.3 10.2 9.7 4.8 8 51.9 65.5 66.7 50.0 52.5 102.5 24.1 55.2 79.3 PSG
R H Porto 7 5 12.8 11.7 5.0 5.0 9 58.3 52.4 50.0 39.0 57.1 96.1 23.3 83.3 106.7 Porto
W B Real Madrid 19 7 16.0 8.5 6.3 4.3 12 73.1 65.3 59.4 39.6 49.0 88.6 50.0 73.1 123.1 Real Madrid
R G Schalke 19 7 14.3 7.3 6.5 3.2 15 73.1 66.2 67.2 45.3 56.8 102.2 48.7 63.2 111.9 Schalke
W H Shakhtar 15 3 13.7 10.2 6.7 4.2 14 83.3 57.3 61.5 48.8 59.0 107.8 37.5 88.0 125.5 Shakhtar
G Sporting Lisbon 8 20 10.2 12.8 4.3 6.7 6 28.6 44.2 39.4 42.6 48.1 90.7 30.8 50.0 80.8 Sporting Lisbon
R C Zenit 12 9 15.5 10.3 5.8 4.8 10 57.1 60.0 54.7 37.6 53.2 90.9 34.3 69.0 103.3 Zenit
Leage Average 11 11 12.6 12.6 5.7 5.7 50.0 50.0 50.0 45.2 54.8 100.0 32.1 67.9 100.0 Leage Average

Tuesday, 2 December 2014

A History Of Premier League Title Winners & What It Means For Chelsea

During this cold and rainy evening in what is normally the mild and bright month of December in Barcelona, I decided to clean up a couple of tired and messy databases that I am in possession of. During this clean up I realized a couple of things: I only watch sports so I have an excuse to use a spreadsheet and I have data on all worlds of weird and wonderful topics.

One of the interesting topics was a database titled 'The History Of Premier League Title Winners'. This database was opened and there on the page in front of me was every Premier League title winner in the 38 game era and each teams cumulative points total over the course of the season.

Why was this database interesting? Well, let me show you....


(Bigger Link)

So, anyone see anything interesting there? I have highlighted Chelsea over the first 13 games to make it easier for you. Still nothing? Well, much to my astonishment I realized that there have been teams that secured more points over the first 13 games of a season than Chelsea have this year (33).

Three teams have achieved this feat: Manchester City in 11/12, Manchester United in 06/07 and Chelsea in 05/06. It is also worth noting that 2 other teams have matched Chelsea's haul of 33 points over the course of the first 13 games: Chelsea in 09/10 and Arsenal in 03/04.

The 5 teams mentioned were all darn good. The points totals for this gang of five range from 86 to 91 come the end of the season. We could just leave this mini-investigation here and say 'hey, teams with 33 points from their first 13 games are all really good teams and end up winning the league in that given year'. Yet this statement would ignore the teams who had 33 points or more from the same number of games who didn't win the league.

So I dredged through some old Premier League tables and found 8 teams who had 33 points or more from the first 13 games. Why did I go to such trouble? I wanted to see how those teams performed over the remainder of their respective schedules after they had gotten off to such hot starts.

Here are those 8 teams with their points totals in the first 13 games and their points totals over the remaining 25 games.



Points First 13 Games Next 25 Games PPG First 13 Games Next 25 Games
Arsenal 03/04 33 57 Arsenal 03/04 2.54 2.28
Chelsea 05/06 34 57 Chelsea 05/06 2.62 2.28
Man United 06/07 34 55 Man United 06/07 2.62 2.20
Chelsea 09/10 33 53 Chelsea 09/10 2.54 2.12
Man City 11/12 35 54 Man City 11/12 2.69 2.16
Man United 09/10 34 57 Man United 09/10 2.62 2.28
Arsenal 07/08 33 50 Arsenal 07/08 2.54 2.00
Newcastle 95/96 34 47 Newcastle 95/96 2.62 1.88
Average 33.8 53.8 Average 2.60 2.15

The average points haul over the next 25 games is ~54. This number is dragged down by a single point by Newcastle's famous collapse in the 95/96 season. If we look across the table we can see that every single team saw a drop off in points per game in the next 25 games of the season.

Why did this happen? 13 games is a short span where luck can run hot, injuries haven't yet taken their toll, "form" is excellent, the schedule is soft and forgiving and all these things may have contributed to a points pace that was likely unsustainable over the remainder of the season. Injuries, fatigue, cooling off of some hot luck and a stiffer schedule may have led to a drop-off of the points pace.

The average points per game pace of this group fell by 0.45 points per game over the remaining 25 games of this season. In real terms this is a drop off of 11 points from any points projections that may have been made at the 13 game mark.

11 points is a significant number: Chelsea are on course for 96 points as it stands. The above table, while not concrete evidence, at least hints at some form of regression in terms of points per game pace.

Let's say Chelsea win 54 points from their remaining 25 games to finish on a total of 87 points from 38 games. Does that sound reasonable? It feels a touch low but if true then Chelsea's record over the next 25 games would look something like this:

Chelsea
Win 16
Drawn 6
Lost 3

Right now it seems impossible that Chelsea would drop points in 9 of their next 25 games but 54 points is the ball park figure for a team who recorded 33 points in their first 13 games. But you know, as much as that W/D/L line looks a little crooked it still results in Chelsea recording 87 points. 87 points is a lot of darn points and good enough to win the Premier League in 13 of the last 20 seasons.

You know what else 87 points is? Almost impossible for Manchester City to match.

Manchester City currently sit on 27 points from their first 13 games. It's a decent haul but it's a ways behind where Chelsea currently sit. This is the record Manchester City would have to post to get to the 87 points I have projected for Chelsea:

Manchester City
Win 19
Drawn 3
Lost 3

Now that is a difficult ask my friends. How on earth could Manchester City pull that off? I could find only six teams in the last 20 seasons who had 60 points or more from their last 25 games. Do you want to know who one of those teams was? Manchester City in 13/14: 61 points with a W 19 D 4 L 2 record.

With Manchester City's soft schedule over the next seven or so games I'd expect the papers/media to begin talking up Manchester City and chipping away at premature bullshit like this: