 Extra Crispy  | 03 Mar 2013 10:05 p.m. PST |
Okay so I can't seem to figure out how to get Excel to do this…. Thinking of D6s here. If I have a target number (roll equal to or exceed), I want Excel to calculate the spread of successes for a given number of dice. SO with a target of 5+ and rolling, say, 5 dice, what are the chances of 0,1,2,3,4,5 successes? Or for 10 dice, what's the spread? Is there a formula or do I just need to grind it out? |
| Rudi the german | 03 Mar 2013 11:34 p.m. PST |
Every target nummber is 16 procent on a d6.. You dont need excel for that. Can be calculated in game. Example Hit on 5-6 is 32 procent. 10 sided dice is every hit nummber 10 procent. Divide 100 procent by the number of sides of your dice and multipy it with the number of rolls inorder to het the procent to score at least one hit.. Calculate this alway in the split second you roll the dice and compare the result with you chance…. Than you know if you are a lucky general… I do this this years and it i makes me very Zen in games. Bad games (like gw) demand conditional rolls, than add up all procent and divide by the number of conditions. Can still be done in split second. Greetings |
| NoLongerAMember2 | 03 Mar 2013 11:48 p.m. PST |
I've got an Excel sheet with some code that I've written to calculate this. Can you PM me a good email for me to send it to? |
| Dale Hurtt | 03 Mar 2013 11:48 p.m. PST |
Rudi, I think you missed the question. It is not the probability to roll a 5+ on a single die, but the probability to roll only 1, 2, 3, etc. on five D6, ten D6, etc. There are plenty of dice probability calculators out there Mark. link |
| vexillia | 04 Mar 2013 3:10 a.m. PST |
|
| advocate | 04 Mar 2013 3:16 a.m. PST |
I think you may be looking for the Binomial function, BINOMDIST. Googling will tell you what you need to know to use it (it worked for me). |
| sharkbait | 04 Mar 2013 4:55 a.m. PST |
Like advocate said, use the BINOMDIST function in Excel. See also here: TMP link |
| freewargamesrules | 04 Mar 2013 11:27 a.m. PST |
|
| Marshal Mark | 04 Mar 2013 12:13 p.m. PST |
10 sided dice is every hit nummber 10 procent. Divide 100 procent by the number of sides of your dice and multipy it with the number of rolls inorder to het the procent to score at least one hit Rudi, as well as not understanding the question, you have your maths wrong. To get the probability of scoring at least one hit, you need to do (1 – probability of no hits). |
| Who asked this joker | 04 Mar 2013 12:44 p.m. PST |
Troll Roller will do that easily if you are just trying to figure out probabilities. Go here… topps.diku.dk/torbenm/troll.msp And put this code in the window and hit calculate probabilities. A:=5; \\change this value
B:= A d6;
C:= count 5<=B;
C Change the value of A to the amount of dice being rolled. In the output, the first column (%=) gives you the chance for getting exactly that number of successes. The second column (%>=) gives you the chance of getting that number or more of successes. |
