With ETF2L's 23rd season over, I've started to look at the results from all the games in an attempt to analyse the 5cp map system* and identify any areas for potential improvement. The hardest and dullest part of that was creating a spreadsheet containing the results from every match this season (excluding playoffs). Since some of you probably know more about statistical analysis than I do, and most of you know know more about TF2 than I do, I thought I'd share the raw data for anyone to grab and have a look through, should they wish to.
You can find the spreadsheet here:
https://docs.google.com/spreadsheets/d/1raVJMm-uAE-aW8hkj1U0lzkdKtWYP_XQviKg4yrgp38/edit?usp=sharing
At a quick glance, there are a few interesting facts to glean, such as:
- A total of 968 5cp maps were played this season
- 34% of maps were ended by the windifference 5 rule
- 9.5% of maps went to a golden cap
Looking closer there are more specific insights, such as:
- Half of all golden caps in Prem were on cp_sunshine
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
I'm sure one could infer many things from the data here, but I wanted to provide it in an unbiased manner for this thread. It does have its limitations, but it could still be useful.
If you have any suggestions on how to use the data, or improve its presentation, or any questions regarding the data, or if you spot any mistakes** please let me know!
Enjoy!
*I do include the koth_product data in the spreadsheet, but I chose to exclude it from larger analysis because of its different ruleset.
**Since this is taken from the results page, it relies on the results being submitted correctly, which in many cases they were not, though I think I spotted them all. Also there's about a 1% chance of a mistake in data entry but again I've hopefully found those.
With ETF2L's 23rd season over, I've started to look at the results from all the games in an attempt to analyse the 5cp map system* and identify any areas for potential improvement. The hardest and dullest part of that was creating a spreadsheet containing the results from every match this season (excluding playoffs). Since some of you probably know more about statistical analysis than I do, and most of you know know more about TF2 than I do, I thought I'd share the raw data for anyone to grab and have a look through, should they wish to.
You can find the spreadsheet here:
https://docs.google.com/spreadsheets/d/1raVJMm-uAE-aW8hkj1U0lzkdKtWYP_XQviKg4yrgp38/edit?usp=sharing
At a quick glance, there are a few interesting facts to glean, such as:
- A total of 968 5cp maps were played this season
- 34% of maps were ended by the windifference 5 rule
- 9.5% of maps went to a golden cap
Looking closer there are more specific insights, such as:
- Half of all golden caps in Prem were on cp_sunshine
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
I'm sure one could infer many things from the data here, but I wanted to provide it in an unbiased manner for this thread. It does have its limitations, but it could still be useful.
If you have any suggestions on how to use the data, or improve its presentation, or any questions regarding the data, or if you spot any mistakes** please let me know!
Enjoy!
*I do include the koth_product data in the spreadsheet, but I chose to exclude it from larger analysis because of its different ruleset.
**Since this is taken from the results page, it relies on the results being submitted correctly, which in many cases they were not, though I think I spotted them all. Also there's about a 1% chance of a mistake in data entry but again I've hopefully found those.
Crasp- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.
[quote=Crasp]
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
[/quote]
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.
DavidTheWinCrasp- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.
Sure thing, I'll take a look tomorrow. Prem is mercifully tiny so depending on how much time I have I might look older seasons as well.
[quote=DavidTheWin][quote=Crasp]
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
[/quote]
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.[/quote]
Sure thing, I'll take a look tomorrow. Prem is mercifully tiny so depending on how much time I have I might look older seasons as well.
DavidTheWinCrasp- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.
I've put together the results from Prem for seasons 21-23. The map pool hasn't changed at all across those seasons, which makes things nice and tidy. I'm assuming that by "previous seasons" you meant just Prem, rather than all divisions, primarily because that would take a lot longer.
This extra spreadsheet is available here:
https://docs.google.com/spreadsheets/d/1vI_-UMm04D2H-tvG5mmKVlZareZ6mB6Js1OlPU5wJHs/edit?usp=sharing
A few graphs from the data:
http://i.imgur.com/pP3GN7K.png
The proportion of maps being decided by windifference has definitely decreased from season 21 to 23. Along with the increase in golden gap percentage, it would be fair to say that season 23 was closer overall.
http://i.imgur.com/XT4LmoG.png
This graph shows how the mean scores for the winning/losing teams, the gap between winner and loser, and the total rounds per map has changed over the seasons. There are less than 50 maps per season, so the changes aren't that significant, but there is a slight trend towards less rounds per map overall, with the losing team winning more of those rounds. Again this could be used to suggest that season 23 was closer than previous seasons.
I'd like to get more graphs up for the larger sheet, but so far the presentation hasn't been to my liking. Again I'm happy to take requests on things to look at.
[quote=DavidTheWin][quote=Crasp]
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
[/quote]
Any chance you could compare that to previous seasons? This season was much closer but it would be interesting to see how much closer it was.[/quote]
I've put together the results from Prem for seasons 21-23. The map pool hasn't changed at all across those seasons, which makes things nice and tidy. I'm assuming that by "previous seasons" you meant just Prem, rather than all divisions, primarily because that would take a lot longer.
This extra spreadsheet is available here:
https://docs.google.com/spreadsheets/d/1vI_-UMm04D2H-tvG5mmKVlZareZ6mB6Js1OlPU5wJHs/edit?usp=sharing
A few graphs from the data:
[img]http://i.imgur.com/pP3GN7K.png[/img]
The proportion of maps being decided by windifference has definitely decreased from season 21 to 23. Along with the increase in golden gap percentage, it would be fair to say that season 23 was closer overall.
[img]http://i.imgur.com/XT4LmoG.png[/img]
This graph shows how the mean scores for the winning/losing teams, the gap between winner and loser, and the total rounds per map has changed over the seasons. There are less than 50 maps per season, so the changes aren't that significant, but there is a slight trend towards less rounds per map overall, with the losing team winning more of those rounds. Again this could be used to suggest that season 23 was closer than previous seasons.
I'd like to get more graphs up for the larger sheet, but so far the presentation hasn't been to my liking. Again I'm happy to take requests on things to look at.