We can then use the teams statistic to find out

Collaborate on cutting-edge hong kong data technologies and solutions.
Post Reply
phonenumber
Posts: 10
Joined: Sun Dec 22, 2024 8:55 am

We can then use the teams statistic to find out

Post by phonenumber »

Tweet Guardian question

We can use the tree tool again to answer this, as it is very good at showing ordered records. We firstly need to create a variable that can identify all the teams in a league in a given season together.

League tier season

We then also need to know email list providers in germany the total number of points each team scored in a season. This can be done using the aggregation wizards.

By using these as dimensions on a tree, how many teams ended up on the same number of points in each season. Sorting would quickly identify an incredible season where eight teams ended up on the same number of points! (Note 2)

We then can add statistics for the maximum goal difference and the minimum goal difference for each of those teams on the same number of points, and then a calculated measure which is the difference between the two values.

The biggest such difference in this century was in the 3rd tier in 2018 when two teams (Bristol Rovers and Rochdale) finished on 54 points with goal differences of -3 and -33 respectively (giving a difference of 30) between those two teams, as shown below.

League tier season

Image

However, there are many instances in history where there were much wider goal differences between teams that finished on the same number of points. Back in 1895, two teams (Liverpool and Manchester City) finished on 46 points in tier 2 but with a goal difference of 49 between them. The list below shows all of the occurrences where the difference is at least 35.
Post Reply