What is significant about East Anglian football?
Posted: Mon Dec 23, 2024 4:30 am
The Apteco Datathon
We know that a team will only ever be in one division each season, so as long as we set the reporting points of the segmentation to be during the season then that team is in that segment at that point in time (4).
We can now use the retention tool to look at how long each team has been in any division from any given season. We only need to check which segment a team is in once a year as they cannot change more regularly than that. By setting our bands to one yearly, we can then break the teams down into exactly how many years cyprus mobile number they have been in the division for. This gives us some expected results – the first column here (3, 6, 7, 6) shows the teams that were promoted/relegated into that division for this season.
The Apteco Datathon: 5. What is significant about East Anglian football?
If we look at the team that was in division 2 (Championship) for 16 years we find the team that has remained in the same non-top division for the longest period of time is Ipswich (6). The teams in division 3 and 4 who have been there for 11 and 12 years respectively are Walsall and Accrington.
Here’s one final piece of segmentation related analysis. Which football club has changed divisions the most times in the last 10 years? And how many times?
We can use the Segmentation Journeys tool to answer this question. By setting the start and end points of the journey to be 01/01/2009 and 01/01/2018 and with eight intermediate points we can look at the divisions a team has been in during the last 10 years (here A,B,C,D represent the divisions 1-4 respectively).
We know that a team will only ever be in one division each season, so as long as we set the reporting points of the segmentation to be during the season then that team is in that segment at that point in time (4).
We can now use the retention tool to look at how long each team has been in any division from any given season. We only need to check which segment a team is in once a year as they cannot change more regularly than that. By setting our bands to one yearly, we can then break the teams down into exactly how many years cyprus mobile number they have been in the division for. This gives us some expected results – the first column here (3, 6, 7, 6) shows the teams that were promoted/relegated into that division for this season.
The Apteco Datathon: 5. What is significant about East Anglian football?
If we look at the team that was in division 2 (Championship) for 16 years we find the team that has remained in the same non-top division for the longest period of time is Ipswich (6). The teams in division 3 and 4 who have been there for 11 and 12 years respectively are Walsall and Accrington.
Here’s one final piece of segmentation related analysis. Which football club has changed divisions the most times in the last 10 years? And how many times?
We can use the Segmentation Journeys tool to answer this question. By setting the start and end points of the journey to be 01/01/2009 and 01/01/2018 and with eight intermediate points we can look at the divisions a team has been in during the last 10 years (here A,B,C,D represent the divisions 1-4 respectively).