Top one's essentially what the year on year ones from the article should've looked like but I've done it for the average over the 11 seasons of data since LDL asked. Bottom one just shows the average transfer and wage spend with the average league position overlayed for some perspective on performance. Could have put a bit more effort into them but then again I could also charge you please log in to view this image I could do some more tomorrow if anyone's bothered as I've got all the year on year data from the article.
And those filthy goons do love their charts and numbers. They have to have something to cling to, bless them, even if it is only a very impressive set of stats for net transfer spend.
What did you do for West Ham and Newcastle's league positions when they weren't in the Premier League, YV? Did you count 1st in the Championship as effectively 21st in the Premier League?
Oh yeah I forgot to qualify it, I only used data from when they were in the PL so for the seasons they weren't in the league everything was left blank and the averages calculated from one less season. The problem with including Championship seasons is I can't add in the net transfer figures as I'd have to use the same source as the guy that made the article and I don't know what he used. All in all it was not worth the effort to find out and the graph still shows West Ham have spent loads for a pile of **** Edit: City also got relegated for a year and Fulham were in the Championship but essentially the figures are sound
The journalist probably used http://www.transferleague.co.uk/ That'd be my guess, anyway. The figures seem to tally, at a quick glance.
That reminds me, I'm supposed to be doing a five variable statistical analysis of PL data for someone on JA (wages, stadium size, revenue, goals scored etc) .
Well I hope you find this resource useful RD. Arguments about who spends what are rife on message boards/ forums all over football fandom, so something like this is great for such debates.
The plan is to objectively see what the correlations are between pairs of key variables, to see which ones are more significant re where you finish in the PL.
Mmm sounds impressive but daunting I'll guess at goals scored and wages over the past 5 years - if it's over the whole of the Prem, that would be very hard work to collate, but I'd still go for the same top two variables pure guess obviously, could be well wrong
