Best performing cities (1 Viewer)

[mrtrench]

Just because I had 30 mins I looked up the population of the 20 biggest cities on Wikipedia. I determined how many top flight clubs are in each city and then divided the current position in the league of the worst team in that area by the population per team - as some kind of calculation on which are the best and worst performing cities.

Hull came top, followed by Brighton and then Newcastle. We came 16th, so we are only slightly punching below our weight as we are the 13th most populated. The Wirral came last as I don't think they have any teams and their population is 331k (Liverpool is quoted separately). London came second last due to Charlton's position and the huge population in London shared 8 ways.

I cannot load a picture unless it's on the interweb so I've pasted what I can below - pretty indecipherable probably.

"Pop
Rank" City Population Number of teams "Population/Teams" "No. WorseTeams" "Position/Population"

20 Hull 256,100 1 256,100 73 0.0285
18 Brighton and Hove 273,400 1 273,400 70 0.0256
16 Newcastle 279,100 1 279,100 71 0.0254
11 Leicester 329,600 1 329,600 77 0.0234
4 Liverpool 830,112 2 415,056 85 0.0205
9 Bournemouth and Poole 382,536 1 382,536 78 0.0204
8 Bristol 428,234 2 214,117 37 0.0173
6 Sheffield 551,800 2 275,900 47 0.0170
7 Teesside 472,200 1 472,200 75 0.0159
17 Bolton 277,300 1 277,300 44 0.0159
15 Bradford 293,717 1 293,717 43 0.0146
10 Stoke-on-Trent 360,810 2 180,405 26 0.0144
3 Manchester 1,741,961 2 870,981 86 0.0099
5 Leeds 750,700 1 750,700 68 0.0091
19 Plymouth 256,384 1 256,384 22 0.0086
13 Coventry 316,900 1 316,900 24 0.0076
2 Birmingham 2,293,099 4 573,275 35 0.0061
14 Nottingham 303,900 2 151,950 5 0.0033
1 London 8,294,058 8 1,036,757 33 0.0032
12 Wirral 331,232 0 #DIV/0! 92 #DIV/0!

 

---

[shmmeee]

Go to imgur.com and upload there, then right click "Copy Image address" and post here.

Though to be honest I have no idea what your numbers mean even though I can work out which is which. Is higher better or worse? And isn't Wirral just Liverpool?

Surely you should take the average between the number of teams when looking at teams below them, why take the worst?

Why are Walsall counted as Birmingham?

More questions than answers here.

 

[Brylowes]

Some of you're populations are for the actual cities and some are for urban areas,
E.g. Population of Liverpool is around 500.000 the same for Manchester.
Urban area of Nottingham is over 600.000 yet you have put the city population
Proper, Teeside isn't a city it's a county.
Why would you split London 8 ways when it has 11 clubs, some would say more.
Where do Tranmere play ?
Since when does Birmingham have 4 clubs.

 

[mrtrench]

I just took the top 20 cities population from wiki. This is a ten minute thing guys; not claiming it's perfect.

 

[Peter Billing Eyes]

Your population stat for Coventry is way off. ONS recorded Coventry's population as 342525 in 2015. Also, Coventry maybe 13th largest in the U.K (not England)., but that includes Belfast, Cardiff, Glasgow and Edinburgh, 3 of which don't play in the EFL. Cov is currently vying with Leicester for 8th largest city, although Leicester has a larger urban area and that includes Oadby and Wigston which aren't technically part of the city. It's a good try but any attempt to define city size based on your data is difficult. I think you have used some of the city metric data and it's wildly inaccurate.