Quote:
That spreadsheet lists the DB drop rate for the Witch Tower as 0.45%. The number of iterations required to render that degree of statistical analysis numbers well into the thousands, if not tens of thousands.
While in principle I would agree with you, the fact that it's listed as "0.45%", even if it's just #Events/#Samples, implies that it's well over 200 samples and the mere fact that it seems that it's possible to do 200 DB without a single Witch Tower drop renders the drop as "practically nonexistant", as the relative value of a Witch Tower contributes a mere 200 coins (or less) to the value for practical reasons. One might as well evade to other adventures with a higher average ROI and resort to buying other styles of settler residence over doing DB. Yes.
Quote:
And just to be clear, I am not trying to discredit the entire spreadsheet. For larger percentages, such as how often Granite/ExoWood/TitOre/Salt drops, smaller sample sizes can render reasonably accurate information with little margin of error.
There is another possibility which is highly accurate, and that is disseminating server messages.