Talk:Gorgon and Mighty Gorgon: Difference between revisions
Jump to navigation
Jump to search
Created page with "== Death Stare Calculation == 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): <nowiki>"=IFERROR(COMBIN($A2,B$1)*(0.1^B$1)*(0.9^($A2-B$1)),0)"</nowiki> *Excel tab 2 formula (clamp to maximum killed): <nowiki>"=IF(B$1<CEILING.MATH(($A2)/10), Unmod!B2, IF(B$1=CEILING.MATH(($A..." |
mNo edit summary |
||
| Line 3: | Line 3: | ||
*Excel tab 1 formula (base # killed): <nowiki>"=IFERROR(COMBIN($A2,B$1)*(0.1^B$1)*(0.9^($A2-B$1)),0)"</nowiki> | *Excel tab 1 formula (base # killed): <nowiki>"=IFERROR(COMBIN($A2,B$1)*(0.1^B$1)*(0.9^($A2-B$1)),0)"</nowiki> | ||
*Excel tab 2 formula (clamp to maximum killed): <nowiki>"=IF(B$1<CEILING.MATH(($A2)/10), Unmod!B2, IF(B$1=CEILING.MATH(($A2)/10), SUM(Unmod!B2:Unmod!$M2), 0))"</nowiki> | *Excel tab 2 formula (clamp to maximum killed): <nowiki>"=IF(B$1<CEILING.MATH(($A2)/10), Unmod!B2, IF(B$1=CEILING.MATH(($A2)/10), SUM(Unmod!B2:Unmod!$M2), 0))"</nowiki> | ||
NOTE: This is based on the [https://en.wikipedia.org/wiki/Binomial_distribution Binomial Distribution] formula of '''combinations(n,k) * p<sup>k</sup> * (1-p)<sup>n-k</sup>''' 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. --[[User:Legate|Legate]] ([[User talk:Legate|talk]]) 18:02, 14 February 2025 (UTC) | 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. --[[User:Legate|Legate]] ([[User talk:Legate|talk]]) 18:02, 14 February 2025 (UTC) | ||
Revision as of 18:17, 14 February 2025
Death Stare Calculation
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)
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% |