"Excel Formula Help Pleaze..." Topic

I want to see if I can populate a spreadsheet as follows without having to do it manually.

For a given number of D6, the chance for a given number of successes, where a success is a certain value or higher.

Example: 21 dice, 11 hits, 3+
What formula (if possible) translates to:
=Chance to roll 11 dice with a number of 3 or greater.

Can this be done with a forumla?

I think

number of successes
divided by
total number of outcomes
divided by
number of anticipated number of successes

your example
21 dice * number sides to hit / 21 dice * 6 sides / 11 hits
(21*4) / (21*6) / 11 = about 6%

Depends on how the problem is defined.

If you want EXACTLY 11 successes (success is 3+ or prob. of success 4/6) out of 21 dice on D6 then try,

=BINOMDIST(11,21,4/6, FALSE)

If, on the other hand, you want to know the probability of rolling 11 or more successes with a success on 3+ then try,

=1 – BINOMDIST(10,21,4/6,TRUE)

I bow before the wisdom of the Excel gurus.

I actually want to calculate a whole table. Columns are # Dice Thrown. Rows are number of hits scored. Cells are chance of exactly that number of hits. I will try BINOMDIST and see if that is what I need.

EDIT Looks like that was exactly what I wanted, thanks!

Use anydice far easier and I think this what you wanted above – anydice.com/program/66b7.

--
Martin Stephenson
The Waving Flag | Twitter | eBay

I know about any dice. It requires you to do each column manually then enter them in Excel. My starting table is 20x25 so no go there!

ugh, kids today want everything right now!
20x24? shouldnt take more than a week to fill in.

Clearly you have too much time on your hands.

Actually I'm doing 4 of them! I am replacing the buckets of dice in Flames of War with a chart using 2D6….