Yes, this is what I had in mind, as what was more insightful for me in this metric/comparison (and not to say the initial data wasn't valid, I was just worried that people might be misinterpreting it). And apologies if I stated my intent in an unclear way; your chart is correct for my intent (ie: you can "shift down and read across", or "read diagonal upwards", those are the same).So the Diagonals reveal the snapshot. For example, when the girls from the 2011 year went from 9v9 to 11 v11, there were 158 teams formed. The G2012 are moving from 9v9 to 11v11 right now, 2024, and they have enough players to form 190 teams.
The diagonals allow for comparison of different age years at the same point in the overall cycle.
What the first table displays is interest/participation history for the individual years. That was what interested me more, who is getting more or less excited about playing soccer. I put in the 11 v 11, 9v9, 7v7 markers as reminders to be taken into account.
Take homes from the "steady age range" diagonal data:
- Participation in boys soccer is increasing across the board, and significantly (~20% YoY increases for almost all age ranges)
- Participation in girls soccer is increasing for lower ages, decreasing a bit at older ages, but more steady-state overall
- No clear correlation with any team/field size changes
In particular, it's more clear in this display (in my view, at least) that girls soccer is not "losing" teams on average, there's just less uniform increase in participation as with the boys.