Results 1 to 6 of 6

Determining dice probabilities

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    Western Mass
    MS-Off Ver
    Excel 2003
    Posts
    15

    Determining dice probabilities

    I have only managed to figure out how to do this with two dice by creating a result matrix and using countif() to find occurrences of a a particular sum.

    I'm trying to create a formula, or whatever solution works, to determine what the probability of getting a certain sum on dice is.

    Example: you roll 3 six sided dice and want to know the distribution of results for possibilities 3 through 18.

    Also what if I want to change my dice to four six sided dice, but only keeping the highest three results? My range stays 3 to 18 but the mean and deviation should be higher and lower respectively.

    Any thoughts?
    Last edited by tedcahill2; 05-25-2018 at 09:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Slice and dice data
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2018, 07:55 AM
  2. Calculating Six Sided Dice Probabilities
    By MadWelshWizard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2017, 05:26 PM
  3. how to input all combinations for 6 dice
    By demonuga in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 08-21-2015, 05:55 PM
  4. Replies: 1
    Last Post: 03-25-2014, 10:46 AM
  5. Excel 2007 : RANDOM dice NOT FAIR
    By vazi01 in forum Excel General
    Replies: 6
    Last Post: 02-18-2010, 11:39 PM
  6. Probabilities, random numbers and dice throws
    By Galamdring in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-06-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1