Reply to thread

Message

<blockquote data-quote="bms" data-source="post: 5788399" data-attributes="member: 6671191">Hi, looking for a stats master here.I have a grid in Excel of all my PCs skills, and I extrapolated that into 3 grids, listing their % likelihood of accomplishing an Easy, Avg or Hard skill check.What I would like to know is how do I compute the probability of at least 3 of the 5 characters succeeding at a given check.I'm a bit hazy on independent probabilities, I think I would basically have to calculate the probability of each possible success scenario (a+b+c succeed, a+c+d, a+d+e, b+c+d, b+d+e, etc etc), and add them all up.&nbsp; That's a lot!&nbsp; There must be an Excel function to help with this.If you care to actually show me, the grid is like this:&nbsp; &nbsp; &nbsp;&nbsp; ___A__B__C___D__E__1|pc1&nbsp; pc2&nbsp;&nbsp; pc3&nbsp;&nbsp; pc4&nbsp;&nbsp; pc52|.25&nbsp; .33&nbsp; &nbsp; .89&nbsp; &nbsp; .65&nbsp;&nbsp; .77Any suggestions?thanks,MikePS:&nbsp; is there a way to search the forums directly?&nbsp; I tried a google domain search on enworld.org with lots of probability hits, but all of them were about the broken skill challenge system in its various incarnations.</blockquote>

[QUOTE="bms, post: 5788399, member: 6671191"] Hi, looking for a stats master here. I have a grid in Excel of all my PCs skills, and I extrapolated that into 3 grids, listing their % likelihood of accomplishing an Easy, Avg or Hard skill check. What I would like to know is how do I compute the probability of [I]at least 3 of the 5 characters succeeding at a given check. [/I]I'm a bit hazy on independent probabilities, I think I would basically have to calculate the probability of each possible success scenario (a+b+c succeed, a+c+d, a+d+e, b+c+d, b+d+e, etc etc), and add them all up. That's a lot! There must be an Excel function to help with this. If you care to actually show me, the grid is like this: ___A__B__C___D__E__ 1|pc1 pc2 pc3 pc4 pc5 2|.25 .33 .89 .65 .77 Any suggestions? thanks, Mike PS: is there a way to search the forums directly? I tried a google domain search on enworld.org with lots of probability hits, but all of them were about the broken skill challenge system in its various incarnations. [/QUOTE]

Verification