0

I'm working on a project that requires I add a unique result for each and every possible ordered outcome of a roll of $4$ dice at one time. I'm stuck on how to show this in Excel or Google Sheets. Any ideas? Really appreciate it.

Rick
  • 1,896
kvn2
  • 1
  • 1
    What do you call ordered outcomes ? Do you mean the values in the order they are drawn ($6^4$ ways), or the sorted values with duplicate 4-tuples removed ($126$ cases) ? –  May 18 '20 at 14:54
  • i mean that a result of: 1,2,1,1 is different than a result of 2,1,1,1.

    Said differently, it matters which die has which result

     – kvn2 May 18 '20 at 15:57

1 Answers1

0

Use the following formulas:

$$n\bmod6+1,\\\left\lfloor\frac n6\right\rfloor\bmod6+1,\\\left\lfloor\frac n{36}\right\rfloor\bmod6+1,\\\left\lfloor\frac n{216}\right\rfloor\bmod6+1$$ for $n$ from $0$ to $1295$. They give you the four dice.

  • Thanks. Is there a way to show the result of that in excel or google sheets? – kvn2 May 18 '20 at 16:45
  • @kvn2: of course, but I am not going to do all the work for you. –  May 18 '20 at 16:47
  • Fair enough haha. You've already been really helpful and I appreciate it. I'll play around w. the formulas in excel to see if i can figure it out. I guess I am just wondering if this 1 formula in 1 cell (repeated 1295 times) or 1 formula in 4 columns (repeated 1295 times) – kvn2 May 18 '20 at 16:59