MagnusIlluminus wrote:
madmagician wrote:
What about finding the geometric mean of the per roll costs and multiplying by 5 turns?
Are you talking about Pulsa Rokkits in specific or Single Shot weapons in general? I'm guessing you mean the former, but not quite sure.
If the former, then no, I'd rather not do that as that would lose accuracy and each entry should be weighed by it's own statistics.
If the latter, then no, as such a weapon can only be fired once over the course of a game.
Sorry that was about the Pulsa Rokkit. I guess I don't see the point of charging it for all 6 possible outcomes.
So my thought is that you take some sort of average or mean of the values of any weapon like this you are capturing the potential damage, not 6x the possible damage simply because it has 6 possible effects.
So your six values based on die rolls are
Code:
1 -- 0.9*(4*7*0.25+1*4*3*0.75)*1.5/6 which equals 2.4
2 -- (0.9*(4*7*0.25+2*4*3*0.75)+2.7*(4*7*0.25+2*4*3*0.75))*1.5/6 which equals 22.5
3 -- (0.9*(4*7*0.25+3*4*3*0.75)+2.7*(4*7*0.25+3*4*3*0.75))*1.5/6 which equals 30.6
4 -- (0.9*(4*7*0.25+4*4*3*0.75)+2.7*(4*7*0.25+4*4*3*0.75))*1.5/6 which equals 38.7
5 -- (0.9*(4*7*0.25+5*4*3*0.75)+2.7*(4*7*0.25+5*4*3*0.75))*1.5/6 which equals 46.8
6 -- (0.9*(4*7*0.9+6*4*3*0.1)+2.7*(4*7*0.9+6*4*3*0.1)+7.2*2*3+10.8*2*3)/6 which equals 37.44
There are quite a few options here.
First is take the basic average (mean) of the values and use that number
(2.4+22.5+30.6+38.7+46.8+37.44)/6 which is 29.74
Put that into the formula like so :
=2*1.5*1.5*29.74 and your number is 133.83. Is that in like with something like the AMTL Vortex missile?
Now it is clear that the lowest value really skews the average low, so we could also do the think where you toss out the outliers although that is way more complicated, since it uses standard deviation (anything outside X standard deviations is tossed)
First figure out the Mean (which we know from above, how handy!) 29.74
Then calculate the deviations of each data point from the mean, and square the result of each
(2.4-29.74)=-27.34 -29.34^2 = 747.48
(22.5-29.74)=-7.34 -7.34^2 = 53.88
(30.6-29.74)=0.86 0.86^2 = 0.7396
(38.7-29.74)=8.96 8.96^2 = 80.28
(46.8-29.74)=17.06 17.06^2 = 291.04
(37.44-29.74)=7.7 7.7^2 = 59.29
The variance is the mean of these values:
1231.71/6 = 205.25
The Standard Deviation is the square root of the variance or 14.33
If we exclude anythign outside of 1 standard deviation
anything lower than 29.74-14.33 = 15.41
or Higher than 29.74+14.33 = 44.07
is excluded
giving us a mean of 32.31
thus a value =2*1.5*1.5*32.31 equals 145.40
Finally there is the geometric mean which will be lower. it is the nth root of the products of n numbers.
(2.4*22.5*30.6*38.7*46.8*37.44)= some huge number but suffice it to say the 6th root is 21.96
thus a value =2*1.5*1.5*21.96 equals 98.82
You could then multiply it by say 4 or 5 rounds since reasonably you are better than 50/50 for rolling a "1
after the 3rd roll. But that still seems to overvalue it. as very few other weapons get dinged for working in more than one round.
Just my thoughts...