Talk:Gorgon and Mighty Gorgon

From Heroes 3 wiki
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. → Phasma 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%