Talk:Gorgon and Mighty Gorgon
Jump to navigation
Jump to search
Death Stare Calculation[edit | hide | hide all]
Need to think of the right way to display this, but I think this should be the info. Top row is # of units killed by death stare, Left Column is # of Mighty Gorgons. Here are my excel formulas to calculate this.
- Excel tab 1 formula (base # killed): "=IFERROR(COMBIN($A2,B$1)*(0.1^B$1)*(0.9^($A2-B$1)),0)"
- Excel tab 2 formula (clamp to maximum killed): "=IF(B$1<CEILING.MATH(($A2)/10), Unmod!B2, IF(B$1=CEILING.MATH(($A2)/10), SUM(Unmod!B2:Unmod!$M2), 0))"
NOTE: This is based on the Binomial Distribution formula of combinations(n,k) * pk * (1-p)n-k where:
- p: probability of Death Stare = 0.1
- n: # of Mighty Gorgons
- k: # of Death Stare victims
My takeaway from this is that it is very important to break into the next set of 10 for # of gorgons as there is a very decent chance of killing the maximum allowed by death stare. --Legate (talk) 18:02, 14 February 2025 (UTC)
- Good job finding this! I think displaying this on the page will be very useful, and the table could be in a collapsible element.
18:47, 14 February 2025 (UTC)
NOTE: Values shown in table are rounded to nearest percent.
0 | 1 | 2 | 3 | 4 | 5 | 6 | |
---|---|---|---|---|---|---|---|
1 | 90% | 10% | 0% | 0% | 0% | 0% | 0% |
2 | 81% | 19% | 0% | 0% | 0% | 0% | 0% |
3 | 73% | 27% | 0% | 0% | 0% | 0% | 0% |
4 | 66% | 34% | 0% | 0% | 0% | 0% | 0% |
5 | 59% | 41% | 0% | 0% | 0% | 0% | 0% |
6 | 53% | 47% | 0% | 0% | 0% | 0% | 0% |
7 | 48% | 52% | 0% | 0% | 0% | 0% | 0% |
8 | 43% | 57% | 0% | 0% | 0% | 0% | 0% |
9 | 39% | 61% | 0% | 0% | 0% | 0% | 0% |
10 | 35% | 65% | 0% | 0% | 0% | 0% | 0% |
11 | 31% | 38% | 30% | 0% | 0% | 0% | 0% |
12 | 28% | 38% | 34% | 0% | 0% | 0% | 0% |
13 | 25% | 37% | 38% | 0% | 0% | 0% | 0% |
14 | 23% | 36% | 42% | 0% | 0% | 0% | 0% |
15 | 21% | 34% | 45% | 0% | 0% | 0% | 0% |
16 | 19% | 33% | 49% | 0% | 0% | 0% | 0% |
17 | 17% | 32% | 52% | 0% | 0% | 0% | 0% |
18 | 15% | 30% | 55% | 0% | 0% | 0% | 0% |
19 | 14% | 29% | 58% | 0% | 0% | 0% | 0% |
20 | 12% | 27% | 61% | 0% | 0% | 0% | 0% |
21 | 11% | 26% | 28% | 35% | 0% | 0% | 0% |
22 | 10% | 24% | 28% | 38% | 0% | 0% | 0% |
23 | 9% | 23% | 28% | 41% | 0% | 0% | 0% |
24 | 8% | 21% | 27% | 44% | 0% | 0% | 0% |
25 | 7% | 20% | 27% | 46% | 0% | 0% | 0% |
26 | 6% | 19% | 26% | 49% | 0% | 0% | 0% |
27 | 6% | 17% | 25% | 52% | 0% | 0% | 0% |
28 | 5% | 16% | 24% | 54% | 0% | 0% | 0% |
29 | 5% | 15% | 24% | 57% | 0% | 0% | 0% |
30 | 4% | 14% | 23% | 59% | 0% | 0% | 0% |
31 | 4% | 13% | 22% | 24% | 38% | 0% | 0% |
32 | 3% | 12% | 21% | 23% | 40% | 0% | 0% |
33 | 3% | 11% | 20% | 23% | 42% | 0% | 0% |
34 | 3% | 11% | 19% | 23% | 45% | 0% | 0% |
35 | 3% | 10% | 18% | 22% | 47% | 0% | 0% |
36 | 2% | 9% | 18% | 22% | 49% | 0% | 0% |
37 | 2% | 8% | 17% | 22% | 51% | 0% | 0% |
38 | 2% | 8% | 16% | 21% | 53% | 0% | 0% |
39 | 2% | 7% | 15% | 21% | 56% | 0% | 0% |
40 | 1% | 7% | 14% | 20% | 58% | 0% | 0% |
41 | 1% | 6% | 13% | 19% | 21% | 39% | 0% |
42 | 1% | 6% | 13% | 19% | 20% | 41% | 0% |
43 | 1% | 5% | 12% | 18% | 20% | 43% | 0% |
44 | 1% | 5% | 11% | 18% | 20% | 45% | 0% |
45 | 1% | 4% | 11% | 17% | 20% | 47% | 0% |
46 | 1% | 4% | 10% | 16% | 20% | 49% | 0% |
47 | 1% | 4% | 9% | 16% | 19% | 51% | 0% |
48 | 1% | 3% | 9% | 15% | 19% | 53% | 0% |
49 | 1% | 3% | 8% | 14% | 18% | 55% | 0% |
50 | 1% | 3% | 8% | 14% | 18% | 57% | 0% |
51 | 0% | 3% | 7% | 13% | 18% | 18% | 40% |