Editing
Talk:Gorgon and Mighty Gorgon
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== 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(($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) * Good job finding this! I think displaying this on the page will be very useful, and the table could be in a collapsible element. [[File:Hero Cosmos small.png|link=user:phasma|β Phasma]] 18:47, 14 February 2025 (UTC) NOTE: Values shown in table are rounded to nearest percent. {| class="wikitable" |- ! !! 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% |}
Summary:
Please note that all contributions to Heroes 3 wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
English
Not logged in
Talk
Contributions
Create account
Log in
Disable DoR
Disable HotA
Disable H3CSS
Namespaces
Page
Discussion
English
Views
Read
Edit
Add topic
View history
More
Purge
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Disable DoR
Disable HotA
Disable H3CSS
Tools
What links here
Related changes
Special pages
Page information