The thread for football nerds!

[Quntib Hollox]

A little while back I was clearing out the loft and came across some books of sporting statistics that I compiled in my youth.
Among them was a list I compiled of where each clubs average league position was calculated from their very first year they joined the football league.
Put simply a team that won the top division would be #1 and for a team finishing say tenth in the championship now, they would be #30 and so on all the way down the football league structure.
So if you added up a club’s total league position and divided it by the number of years in the league you’d get their average position in the football pyramid.
The first list I’ll put up is calculated up to the 1995/96 season. Make of it what you will but it’s one way of measuring a clubs standing in the football structure.

 

[Quntib Hollox]

 

[Quntib Hollox]

I’ll let you digest that and welcome any thoughts.

 

[I'm Red Till Dead]

Someone appears to have done something similar up to 2022 - https://drive.google.com/file/d/18fQMECa2VBbogBXDSElqTvnqOkJ6YUbE/view

There is a bit on their methodologly here - https://alltimeleaguetable.co.uk/statistics-for-all-time-league-table/

 

[Cloughie1975]

View attachment 36725

It really demonstrates the position of Forest in the football world,Mark-(drifting mainly between
the 1st and 2nd tiers over the years).
As IRTD shows,our position has declined since your chart.If we excluded the Clough years
no doubt our rank would go down further.

 

[Redemption]

View attachment 36725

When I last did it, also came 19th. But that was about a decade ago.

In statistics, you would say the distribution is set because annually changes only have a small impact.

It's like if you flip a coin many times, you quickly arrive at the average of circa 50%, within a small range ±0.5% and streaks of heads or tails barely register except in the decimal places.

It can change, but you have to have a long period of good or, in our case now, very bad runs.

 

[Quntib Hollox]

It really demonstrates the position of Forest in the football world,Mark-(drifting mainly between
the 1st and 2nd tiers over the years).
As IRTD shows,our position has declined since your chart.If we excluded the Clough years
no doubt our rank would go down further.

I’ve deliberately held back the up to date version that highlights how the Premier league era has impacted us (and others).

 

[I'm Red Till Dead]

I’ve deliberately held back the up to date version that highlights how the Premier league era has impacted us (and others).

Sneaky.

 

[Strummer]

I’ve deliberately held back the up to date version that highlights how the Premier league era has impacted us (and others).

Premier League Brighton and Hove Albion in 48th!

 

[Quntib Hollox]

Premier League Brighton and Hove Albion in 48th!

Bournemouth and Brentford also batting well above their average!

 

[Quntib Hollox]

It’s a bit skewed in favour of the founder members who had a few years when there was only 12 or so teams in the league. WBA, Blackburn, Bolton are higher than you might expect.
Interesting to me how close together many of the leagues big rivals are to each other. Liverpool/Everton, Arsenal/Spurs, Forest/Derby. Even lower down Southampton/Portsmouth, Blackpool/Preston.

 

[Redemption]

Someone appears to have done something similar up to 2022 - https://drive.google.com/file/d/18fQMECa2VBbogBXDSElqTvnqOkJ6YUbE/view

There is a bit on their methodologly here - https://alltimeleaguetable.co.uk/statistics-for-all-time-league-table/

It’s a bit skewed in favour of the founder members who had a few years when there was only 12 or so teams in the league. WBA, Blackburn, Bolton are higher than you might expect.
Interesting to me how close together many of the leagues big rivals are to each other. Liverpool/Everton, Arsenal/Spurs, Forest/Derby. Even lower down Southampton/Portsmouth, Blackpool/Preston.

It would be interesting to see this on scatter plot. We'd see some interesting clustering I think.

 

[Quntib Hollox]

It would be interesting to see this on scatter plot. We'd see some interesting clustering I think.

We need someone with the IT skills of a certain Mackem forum member to get involved

 

[Redemption]

We need someone with the IT skills of a certain Mackem forum member to get involved

The classic 2 series regression awaits.

 

[Rockabilly]

We need someone with the IT skills of a certain Mackem forum member to get involved

Hold the line please caller....

@Bonfy177

 

[Rockabilly]

Hold the line please caller....

@Bonfy177

@Quntib Hollox @Bonfy177
I've found your man.

 

[Bonfy177]

 

[Bonfy177]

Reet I’ve run the numbers and my findings aren't surprising in the least, it turns out irrespective Forest are magic on and off the pitch.

 

[Quntib Hollox]

This thread could go one of two ways

 

[Rockabilly]

This thread could go one of two ways

 

[Bonfy177]

This thread could go one of two ways

Can ya give us the two options QH ?

 

[Rockabilly]

Can ya give us the two options QH ?

 

[Bonfy177]

I thought when I put a suit on my avatar photo folk might take me a little more seriously around these parts

 

[DanR]

I thought when I put a suit on my avatar photo folk might take me a little more seriously around these parts

Good idea, it's working for me.

But we are starting from a low baseline.

 

[Rockabilly]

@Bonfy177

Off to the pub in Southwick?