Popular Post hidude45454 Posted March 3, 2022 Popular Post Share Posted March 3, 2022 *Everyone that's currently active or in an alliance, idgaf about the rest lmao! Sponsored by DNN: https://discord.gg/MDYdBkzFh4 The full sheet, if anyone wants to check it out: https://docs.google.com/spreadsheets/d/1n0w9tpZIKI_dAdSm2p6PHjDIEAQvxGkmjspNG_Ebs44/edit#gid=914942025 In a moment of boredom I scraped the soldiers/tanks/planes/ships kills/losses of everyone in the game and compiled a bunch of ratios and statistics for your enjoyment. The sheet is pretty self-explanatatory but I screenshotted all the stats anyways just to go into some analysis/explanation of what they mean. Kill Loss Ratio Histograms: Perhaps surprisingly, these histograms peak at about a 0.7-ish kill to loss ratio rather than at an exact 1:1 ratio. This suggests that there is a smaller group of better fighters in the game that can take advantage of a larger pool of worser fighters that skews the graphs. Note that the final peak in all graphs is from all the people who are in the range from the cutoff point to the maximum ratio in that unit (presumably mostly from the raiders in the C1-9 range). Kill Loss Ratio Medians: The overall median and tier-based medians more or less seems to confirm this. Theory: The median of tank, plane, and ship kill ratios increases the higher tiers we get because of 1) Generally more experienced members in higher ranges, and 2) More downdeclaring potential to kill more units. Kill Loss Ratio Percentages: How to read this graph: for ex. if you are a C15 with a 1.2 tank kill loss ratio, that is saying your ratio is better than about 70% of people in that range (not bad!) Kills Per City Trends I used the log of unit kills per city rather than the unit kills per city itself because without it the graphs looked super ugly, lmk if that wasn't the right approach. Here I was curious if lower city nations could pound for pound compete with higher city nations based on kills per city, and from looking at the highest points at each city count the answer appears to be yes, but on the overall higher city nations generally trend higher anyways, probably mostly because they have played the game longer and therefore had more time to kill units. Best and Worst Ratios in Each Tier and Overall Fairly self-explanatory, feel free to tag yourself or your friends who made these lists! 😉 For the overalls, I wanted it to actually look kinda like a legit list so I filtered it only to people with 5m+ soldier losses, or 100k+ tank losses, or 7k plane losses, or 1k+ ship losses (thanks to Ramona for the thresholds.) Outliers Some people might be wondering how tf some people's ratios are so high. As two examples, MIBHG Country (the first linked nation) has built less than 200k soldiers in 2500+ days, and Dusty (the second linked nation) has built literally zero tanks since rerolling (lmao). Obviously neither of these people are particularly good at fighting but have good ratios because of these choices regardless. This is the case with quite a few people, especially the lower you go with raiders and stuff who also primarily target lots of people who don't really know how to fight back. So, just a note that ratios don't mean everything (and I care about total unit kills anyways, but PnW already has a leaderboard for that 😉) Note: I have no experience with statistics classes, so pls no kill if I did something wrong (but please point it out!) Feel free to suggest any additional fun data points to scrape and I will do my best to fill all interesting suggestions. 6 14 Quote Link to comment Share on other sites More sharing options...
Jacob Knox Posted March 3, 2022 Share Posted March 3, 2022 I may not be among the best, but at least I'm better than average haha. Really cool 'report,' man! 1 Quote Federation of Knox Enlightened of Chaos, Event Horizon QA Team and API Team Link to comment Share on other sites More sharing options...
Alice Kryze Posted March 3, 2022 Share Posted March 3, 2022 Ok now this is epic Quote Your fav goth Link to comment Share on other sites More sharing options...
AlexiosKomnenos Posted March 3, 2022 Share Posted March 3, 2022 Very cool! But what was the point of having/using the log kill ratios? (Besides making the graph look pretty, doesn’t that mess with the data?) Also what was the base of the log you used? Quote Link to comment Share on other sites More sharing options...
Cooper_ Posted March 3, 2022 Share Posted March 3, 2022 @hidude45454 I’d be interested to see what the data looks like before you took the logarithm of the y axis. It looks like it might be logistic (your line of best fit isn’t linear) although I don’t imagine the google sheets graphs you’re using has support for such a regression. Would recommend checking out some python packages like numpy, sklearn, and scipi if you’re interested in the data manipulation and learning more from it. R and matlab are also useful options too if you have access to them! Quote Link to comment Share on other sites More sharing options...
hidude45454 Posted March 3, 2022 Author Share Posted March 3, 2022 40 minutes ago, Mr. Berrycloth said: Very cool! But what was the point of having/using the log kill ratios? (Besides making the graph look pretty, doesn’t that mess with the data?) Also what was the base of the log you used? I think it could be be somewhat misleading reading a log graph, but to my understanding I don't think it messes with the data since you can always unlog it. (And it's with a base of 10) 31 minutes ago, Cooper_ said: @hidude45454 I’d be interested to see what the data looks like before you took the logarithm of the y axis. It looks like it might be logistic (your line of best fit isn’t linear) although I don’t imagine the google sheets graphs you’re using has support for such a regression. Would recommend checking out some python packages like numpy, sklearn, and scipi if you’re interested in the data manipulation and learning more from it. R and matlab are also useful options too if you have access to them! Here is the original data, I cleaned up a few data points in order to make it look kind of prettier (I think) Here the best line of fit is kind of linear, which I suspected was the case if a line of fit on a log graph was logarithmic (I can manually choose which type of line I want.) I've used numpy/sk-learn/scipy a little bit before for class stuff so agree that it would probably be good practice, but figured Google Sheets would probably be a bit more accessible and was also feeling a bit lazy at the moment I guess 😜 Quote Link to comment Share on other sites More sharing options...
AlexiosKomnenos Posted March 3, 2022 Share Posted March 3, 2022 1 hour ago, hidude45454 said: I think it could be be somewhat misleading reading a log graph, but to my understanding I don't think it messes with the data since you can always unlog it. (And it's with a base of 10) Here is the original data, I cleaned up a few data points in order to make it look kind of prettier (I think) Here the best line of fit is kind of linear, which I suspected was the case if a line of fit on a log graph was logarithmic (I can manually choose which type of line I want.) I've used numpy/sk-learn/scipy a little bit before for class stuff so agree that it would probably be good practice, but figured Google Sheets would probably be a bit more accessible and was also feeling a bit lazy at the moment I guess 😜 Thanks! I guess it makes sense that the data is linear, wars at higher tiers are fought with more troops. Quote Link to comment Share on other sites More sharing options...
dog dawg cat Posted March 3, 2022 Share Posted March 3, 2022 ratio 2 2 Quote Link to comment Share on other sites More sharing options...
Cassia Posted March 3, 2022 Share Posted March 3, 2022 (edited) Oh hey I actually made an appearance... interestingly my tank ratio is not that good, only 1.7 -- and then 2.8 for planes, 2.5 for ships, so that ain't half bad. Most likely my soldier kill ratio is that high because of how many raiders I countered when I was lower tier. Very interesting data! Edited March 3, 2022 by Cassia Quote Link to comment Share on other sites More sharing options...
SleepingNinja Posted March 3, 2022 Share Posted March 3, 2022 (edited) Don't try to math and look at tons of graphs right after you wake up like this idiot. It's me, I'm the idiot. Edited March 3, 2022 by SleepingNinja math, math is a bane. Quote Link to comment Share on other sites More sharing options...
Sweeeeet Ronny D Posted March 3, 2022 Share Posted March 3, 2022 sounds like some of you guys need to fight some tougher wars. 1 Quote Link to comment Share on other sites More sharing options...
Popular Post Dryad Posted March 3, 2022 Popular Post Share Posted March 3, 2022 @Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein@Vein lmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmaolmao 1 6 1 Quote Link to comment Share on other sites More sharing options...
KillzBob Posted March 3, 2022 Share Posted March 3, 2022 i dont understand anything posted but good job Quote Link to comment Share on other sites More sharing options...
Dusty Posted March 3, 2022 Share Posted March 3, 2022 (edited) 13 hours ago, hidude45454 said: *Everyone that's currently active or in an alliance, idgaf about the rest lmao! Sponsored by DNN: https://discord.gg/MDYdBkzFh4 The full sheet, if anyone wants to check it out: https://docs.google.com/spreadsheets/d/1n0w9tpZIKI_dAdSm2p6PHjDIEAQvxGkmjspNG_Ebs44/edit#gid=914942025 In a moment of boredom I scraped the soldiers/tanks/planes/ships kills/losses of everyone in the game and compiled a bunch of ratios and statistics for your enjoyment. The sheet is pretty self-explanatatory but I screenshotted all the stats anyways just to go into some analysis/explanation of what they mean. Kill Loss Ratio Histograms: Perhaps surprisingly, these histograms peak at about a 0.7-ish kill to loss ratio rather than at an exact 1:1 ratio. This suggests that there is a smaller group of better fighters in the game that can take advantage of a larger pool of worser fighters that skews the graphs. Note that the final peak in all graphs is from all the people who are in the range from the cutoff point to the maximum ratio in that unit (presumably mostly from the raiders in the C1-9 range). Kill Loss Ratio Medians: The overall median and tier-based medians more or less seems to confirm this. Theory: The median of tank, plane, and ship kill ratios increases the higher tiers we get because of 1) Generally more experienced members in higher ranges, and 2) More downdeclaring potential to kill more units. Kill Loss Ratio Percentages: How to read this graph: for ex. if you are a C15 with a 1.2 tank kill loss ratio, that is saying your ratio is better than about 70% of people in that range (not bad!) Kills Per City Trends I used the log of unit kills per city rather than the unit kills per city itself because without it the graphs looked super ugly, lmk if that wasn't the right approach. Here I was curious if lower city nations could pound for pound compete with higher city nations based on kills per city, and from looking at the highest points at each city count the answer appears to be yes, but on the overall higher city nations generally trend higher anyways, probably mostly because they have played the game longer and therefore had more time to kill units. Best and Worst Ratios in Each Tier and Overall Fairly self-explanatory, feel free to tag yourself or your friends who made these lists! 😉 For the overalls, I wanted it to actually look kinda like a legit list so I filtered it only to people with 5m+ soldier losses, or 100k+ tank losses, or 7k plane losses, or 1k+ ship losses (thanks to Ramona for the thresholds.) Outliers Some people might be wondering how tf some people's ratios are so high. As two examples, MIBHG Country (the first linked nation) has built less than 200k soldiers in 2500+ days, and Dusty (the second linked nation) has built literally zero tanks since rerolling (lmao). Obviously neither of these people are particularly good at fighting but have good ratios because of these choices regardless. This is the case with quite a few people, especially the lower you go with raiders and stuff who also primarily target lots of people who don't really know how to fight back. So, just a note that ratios don't mean everything (and I care about total unit kills anyways, but PnW already has a leaderboard for that 😉) Note: I have no experience with statistics classes, so pls no kill if I did something wrong (but please point it out!) Feel free to suggest any additional fun data points to scrape and I will do my best to fill all interesting suggestions. Not particularly good? that hurts me deep🥺, I like my tankless memes Edited March 3, 2022 by Dusty 1 Quote Link to comment Share on other sites More sharing options...
Zei-Sakura Alsainn Posted March 4, 2022 Share Posted March 4, 2022 Damn everybody above me in this are or were long time raiders. I guess some of the farmers actually know how to *use* their pitchforks. 1 Quote Link to comment Share on other sites More sharing options...
Cooper_ Posted March 4, 2022 Share Posted March 4, 2022 23 hours ago, hidude45454 said: I think it could be be somewhat misleading reading a log graph, but to my understanding I don't think it messes with the data since you can always unlog it. (And it's with a base of 10) Here is the original data, I cleaned up a few data points in order to make it look kind of prettier (I think) Here the best line of fit is kind of linear, which I suspected was the case if a line of fit on a log graph was logarithmic (I can manually choose which type of line I want.) I've used numpy/sk-learn/scipy a little bit before for class stuff so agree that it would probably be good practice, but figured Google Sheets would probably be a bit more accessible and was also feeling a bit lazy at the moment I guess 😜 I don’t know how much linear algebra experience you have but a line of best fit will always be linear. Other fits will require a different regression. You use the log-linear plot to show data that spans multiple orders of magnitude easily, I.e an exponential function would look linear. I take back the logistic argument though, seeing the full distribution, this looks pretty linear itself just with a bit of variance from the outliers. Quote Link to comment Share on other sites More sharing options...
hidude45454 Posted March 8, 2022 Author Share Posted March 8, 2022 Second part with infra ratios, from a suggestion from Cassia: The sheet: https://docs.google.com/spreadsheets/d/1n0w9tpZIKI_dAdSm2p6PHjDIEAQvxGkmjspNG_Ebs44/edit#gid=731748600 Destroyed Lost Ratio Histogram: Already here you can see a pretty significant change vs. units, where the peak settles much closer around the 1:1 ratio. Destroyed Lost Ratio Medians: This pretty much confirms the above graph. I think there is a pretty strong theory as to why these numbers are so high -- simply because I only recorded data from active players in alliances. Active players in alliances raid inactive players not in alliances and get easy infra boosts as a result. This is even more true in the lower tiers where raiding statistics factor in much heavier than war statistics. Destroyed Lost Ratio Percentages: Adding to this theory even more, the higher up you go, the more wars factor into that and the lower most people's ratios get, whereas in the C1-9 range most of the raiding actives are well past the 2.5 infra destroyed/lost ratio. Kills Per City Trends Looks pretty much the same as the unit graphs. Best and Worst Ratios in Each Tier and Overall Here some additional, albeit fairly intuitive patterns start emerging -- pirates with not much infra to begin with generally top losts, while crappy farmers who don't know how to fight settle at the bottom. The overall list is filtered only to people with 100k+ infra lost. Shoutout to this dude https://politicsandwar.com/nation/id=159527 for being one of the worst fighters I've ever seen and killing 3.5k infra in 1000+ days 😂 As always, let me know if you have any more interesting suggestions to pull! 3 Quote Link to comment Share on other sites More sharing options...
John M Keynes Posted March 8, 2022 Share Posted March 8, 2022 Nice work on the graph work! It's a different way to show who really is good at fighting and others to well ... just Git Gud mate. Quote My opinion may not reflect those of my alliance or its affiliates. Please read at your own discretion. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.