Editing Template talk:Spell probability table (section)

=== Hopefully I am mistaken? ===
* The problem with this formula is that it assumes spells CAN reappear in subsequent spell slots. If we are looking at a Castle Bless spell (10/100), the chance of it appearing in spell slot 2 depends on which spell was selected for slot 1 (and is not equal to the chance of it appearing in slot 1).
** For example, if the spell selected for slot 1 was Magic Arrow (30/100), the chance for bless to be in slot 2 is 10/70 (since Magic Arrow has already been selected and can't be repeated).
** If instead View Air was selected for slot 1 (3/100), the chance for bless to be in slot 2 is 10/97 (since View Air has already been selected and can't be repeated).

Unless I am misunderstanding this or overcomplicating it, I think the only way to calculate the chance for Bless to be in spell slot 2 would be to sum all the possible ways this could happen...i.e. (x/(100-y<sub>1</sub>)*(y<sub>1</sub>/100) + (x/(100-y<sub>2</sub>)*(y<sub>2</sub>/100) + ... where x is the Bless chance and the y<sub>whatevers</sub> are the chances for all the other spells. This is not bad to calculate for the 2nd spell slot, but gets worse for every additional spell slot that need calculating (as then you need to sum the probabilities for every possible combination of spells in previous slots.
* NOTE: Using this method, the chance for Bless to appear in slot 2 is ~11.94% (given it did not appear in slot 1)

Hopefully I am just overcomplicating this and there is some easy trick to come up with the total percentage for a spell to appear (as that is all we really care about) or we cheat and just Monte Carlo this sucker. :)
 --[[User:Legate|Legate]] ([[User talk:Legate|talk]]) 01:47, 7 October 2024 (UTC)

IMPORTANT NOTE: If we are going to really math this out we should use the actual game values. I believe the table above is just an approximation for what appears in the game files?

P.S. I suppose we could also suck it up and write a quick program to figure this out...probably pretty easy and/or there is one that already does this somewhere on the web.

* These values are from sptraits