Make a small donation to Ye Olde Inn!
Every cent received goes toward Ye Olde Inn's maintenance and allows us to continue providing the best resources for HeroQuest and Fantasy Gaming fans.
Make a small donation to Ye Olde Inn!
Every cent received goes toward Ye Olde Inn's maintenance and allows us to continue providing the best resources for HeroQuest and Fantasy Gaming fans.
clmckay wrote:Apparently, I've forgotten how to use Excel for basic probability.
I've seen some true spreadsheet wizards around here, maybe you cna give me a quick pointer to the right function.
I want to calculate the odds of rolls on the dice referenced in this thread. Soooo.... Odds of at Least 1- 6 Skulls, White and Black Shields with 1-6 dice being rolled.
I thought I'd use the binom.dist function to figure that, for example:
=1-BINOM.DIST(2,6,.5,TRUE)
In this case, the odds of at least 2 Skulls on 6 dice being rolled. This one is givng me odds of a tad over 65%. Now......if I manually calculate it I come with something closer to 87.5%
So either it or I am wrong....Am I using the wrong formula? Perhaps my Stats have left me completely over the years!
clmckay wrote:DOH!
Thanks!
Any thoughts on how to calculate this for the dice sets with 2 Skulls, Shields?
I'm thinking this:
=1-BINOM.DIST(0,6,(2/6),TRUE)*(1-BINOM.DIST(0,6,(1/6),TRUE))
That would be the odds of getting at least 1 Skull with six dice (purple, in this case). It's distribution is: 2Skulls, 1D-Skull, 3-White/Black Shields
Return to Miscellaneous HeroQuest Items
Users browsing this forum: No registered users and 1 guest