Here’s something I put together using Excel, then Google docs. I considered sharing the document, but couldn’t figure out how to do it without compromising my secret Roach identity.
At 0.3%, which is Ant-Man in Enemy of the State (aka new 4*), the odds of drawing 0 from a 10-pack is 97%, from a 42-pack it’s 88%. There’s an 11% chance of getting 1 from the 42 pack.
At 1.4%, which is Elektra in Enemy of the State (aka essential 4* in PVE), the odds of drawing 0 from a 10-pack is 87%, from a 42-pack it’s 55%. You’re 99% likely to get 1 or fewer from the 10-pack, 98% likely to get 2 or fewer from the 42-pack, most likely to get 0.
At 1.8%, which is any of the featured characters in the Lightning Offer, the odds of drawing 0 from a 10-pack is 83%, from a 42-pack it’s 46%. You’re 99% likely to get 1 or fewer from the 10-pack, 96% likely to get 2 or fewer from the 42-pack, most likely to get 0.
At 5.6%, which is Human Torch in Enemy of the State (aka essential 3* in PVE), the odds of drawing 0 from a 10-pack is 56%, from a 42-pack it’s 9%. You’re 98% likely to get 2 or fewer from the 10-pack, 97% likely to get 5 or fewer from the 42-pack, most likely to get 2.
At 6.0%, which is Human Torch in Hot Shot (aka featured 3* in PVP), the odds of drawing 0 from a 10-pack is 54%, from a 42-pack it’s 7%. You’re 98% likely to get 2 or fewer from the 10-pack, 99% likely to get 6 or fewer from the 42-pack, most likely to get 2.
(I think the formatting can be improved, and the column headers changed, but that’s a task for another day)
If you want to do your own spread sheet, it’s easy, the formula that goes in the cell is something like this:
=BINOMDIST(0, 10, 0.06, FALSE)
which gives the chance of getting 0 out of 10 when the drop rate is 6%, not cumulative.