Hi Lusche:
Thanks for putting in all the hard work!!!
There are several issues with the stats however. One major one that needs to be considered is that combining kills+deaths is double counting. I know we went over this issue a long time ago before but it bears repeating. Have you removed the double counting from the equation? If not we have the following major issues.
1) For each model you would be double counting kills/deaths for a given model vs. itself.
2) The aggregate totals for your %'s would also be off by overcounting kills/deaths for all models.
Consider the following matrix:
| | A Kills | B Kills | C Kills | | Total Deaths |
A Deaths | | 5 | 5 | 5 | | 15 |
B Deaths | | 4 | 2 | 9 | | 15 |
C Deaths | | 1 | 1 | 13 | | 15 |
|
Total Kills | | 10 | 8 | 27 | | 45 |
If we us the Kills+Deaths method if we are examining Plane C for instance we would get the following:
15 Kills + 27 Deaths = 42
The problem is this number is double counting the kills and deaths for Plane C vs Plane C so in this scenario we are over counting by 13. The number should be 29, not 42 in this example.
Secondly if we are basing the % on the aggregate totals of all kills + all deaths then the total is off as well because we are including double counts for all models. For instance back to our example if we just count all kills + deaths we get:
45 kills + 45 deaths = 90
Removing the double count in the total would mean subtracting (5+2+13=20). So the total number that we should be using is 70 not 90. The double counting in this case is inflating our total by almost 30%.
Tango, XO
412th FS Braunco Mustangs