Math & Statistics Question

[AAJagerX]

Just substitute .00000000000000001 for your deaths in that catagory.  Close enough right?

[Ardy123]

That is fascinating Ardy

Otherwise known as deaths +1....lol

no one gets my stupid humor...(except for hoff, maybe (can't tell if its at me or because of me)

[Hoff]

K/D would be infinity if you substituted a small number like that. Doing the averaging the way you want to do it is going to cause error in your final calculation. The best thing you can do is make, for example, 2/0 and 2/1 k/d the same. This is obviously not the same, but for whatever reason you need that specific ratio. Your best bet is to do what you are saying, just use an IF statement to make 0 = 1 for death purposes.


@ardy, it was at you, I was hoping you were being facetious  .

[Ardy123]

K/D would be infinity if you substituted a small number like that. Doing the averaging the way you want to do it is going to cause error in your final calculation. The best thing you can do is make, for example, 2/0 and 2/1 k/d the same. This is obviously not the same, but for whatever reason you need that specific ratio. Your best bet is to do what you are saying, just use an IF statement to make 0 = 1 for death purposes.


@ardy, it was at you, I was hoping you were being facetious  .

seriously you don't have to divide it.. you can just have it as a fraction and reduce it as much as possible... so  5/0 or 5/1 (10 kills 2 deaths), etc..

[Jayhawk]

Just substitute .00000000000000001 for your deaths in that catagory.  Close enough right?

5 / .00000000000000001 = 500000000000000000

[AAJagerX]

5 / .00000000000000001 = 500000000000000000

I know.  That was a poor attempt at humor. 

Really though, if there's a zero in your K/D table, just cut out the middle man...  Take out the values in the spreadsheet and substitute your total kills in the sum area.  You don't need real-time calculations do you?

[Jayhawk]

Substituting a 5/0 K/D with 5 would be equivalent to substituting a 5/1 K/D.  Would it have an effect on your results, yes, how big of an effect, well that depends on how much data you've got.

[AAJagerX]

Substituting a 5/0 K/D with 5 would be equivalent to substituting a 5/1 K/D.  Would it have an effect on your results, yes, how big of an effect, well that depends on how much data you've got.

It wouldn't affect it at all if he was running his own spreadsheet (which I think was what he was trying to do).  All you'd have to do is go through and change the sums of your flights without a kill to the total of your kills in that plane.  Depending on how many 0 death planes you have for that tour, it wouldn't be difficult.

If he's talking about changing the K/D +1 in the AH score tables, that's a totally different story.

[Ardy123]

Substituting a 5/0 K/D with 5 would be equivalent to substituting a 5/1 K/D.  Would it have an effect on your results, yes, how big of an effect, well that depends on how much data you've got.

no treat it as a fraction then do math on that fraction... but keep it in fraction form.

[Jayhawk]

no treat it as a fraction then do math on that fraction... but keep it in fraction form.

Except we don't know what he's doing for sure.

[Hoff]

It sounds like he's trying to average his K/D by averaging each individual plane K/D together, which doesn't make sense to me. Someone might have a 100/1 K/D in the 262 but if in their main ride, say a P51D, they have a 5000/4000 K/D then the averages are going to be way off if you average the two K/D's together instead of total kills divided by total deaths (50.625 vs. 1.275).

[Vinkman]

Setting it to K will add 1 to your deaths when there really wasn't a death. I don't know what you're trying to do, but if you're just trying to average kills/death then you just need to take all kills and divide by all deaths. You can't really average an average since they have different scales. You might be 25/1 in one plane and 90/90 in another. If you just went by K/D averages this would come out to be 13, but if you went by total kills/total deaths it would be 1.26.

It would be easier to help you out if I knew exactly what you were trying to do. If, for some reason, you want to average the averages, then you could just use an IF statement for when D = 0 make it D+1 (which can be easily done in excel).

This 

[MrRiplEy[H]]

Just substitute .00000000000000001 for your deaths in that catagory.  Close enough right?

Umm you MIGHT want to rethink that a little..

5 kills divided by .000000000000001 is how much again?

[Dead Man Flying]

I want to calculate a Kill/Death ratio average across X blocks of data. Each block of data will produce its own unique value for K, and for D

Just out of curiosity, what are you hoping to achieve by averaging the quotients?  In almost all cases, it's better to sum the divisors and the dividends and obtain an aggregated K/D score as you did in the last row.

[hitech]

oneway it makes no statistical sense to have a K/D and then trying to magically change the D in special situations. The output of this method would be meaningless because if you change it to 1 when it is zero you would get the same results for 5 kills zero death and 5 kills 1 death.

It may seem to you that your are upsetting the stats by using kill to life, but you are not. What you are seeing is the difference in number of sorties and simple variations do to sample size. And with a small sample size your results are statistically meaningless no matter what you do.

2nd what is it you are trying to accomplish?


HiTechb