+ Reply to Thread
Results 1 to 2 of 2

Simple Probability? Outcome of multiple people picking one of two options

  1. #1
    Registered User
    Join Date
    02-08-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    16

    Simple Probability? Outcome of multiple people picking one of two options

    Hey all,

    I'm trying to find out what I assume will be a simple formula but can't figure it out. The idea is this:

    There 15 people who are all given the same options (Choice1, Choice2).

    What is the probability that all 15 people pick Choice 1
    What is the probability of 10 people picking choice 1 and 5 people picking choice 2

    Something along those lines. I'll adapt this to more or less people and/or choices, just trying to figure out the right way to go about it.

    Thanks in advance!

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Simple Probability? Outcome of multiple people picking one of two options

    With two choices, it's equivalent to tossing a coin (assuming those choices are random).

    For 1 person, there are 2 outcomes: [H, T]
    For 2 people, there are 4 outcomes: [HH, HT, TH, TT]
    For 3 people, there are 8 outcomes: [HHH, HHT, HTH, HTT, THH, THT, TTH, TTT]

    The number of outcomes doubles each time and is equivalent to 2^(#people). 2^15 is 32768. There is only 1 outcome where everyone has chosen the same so the probability of this happening is 1/32768 or approximately 0.0030517578%.

    For the second question, we need to determine how many of those 32768 outcomes result in 10 people picking choice 1 and 5 picking choice 2. Excel has a function for this. Typing =COMBIN(15,10) into a cell (or COMBIN(15,5) - it's the same answer) gives us 3003 so the chance is 3003/32768 or approximately 9.1644%. In fact, the values for picking 0 to 15 of one choice are:

    0.0031%, 0.0458%, 0.3204%, 1.3885%, 4.1656%, 9.1644%, 15.2740%, 19.6381%, 19.6381%, 15.2740%, 9.1644%, 4.1656%, 1.3885%, 0.3204%, 0.0458%, 0.0031%

    Hopefully that makes it clear how to extend this to more people with a binary choice. Once you move up to providing more choices (Choice1, Choice2, Choice3) then the math is going to get much more complex.

    WBD
    Office 365 on Windows 11, looking for rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-26-2021, 01:41 PM
  2. [SOLVED] Multiple IF with AND formula, but One of the options is not returning correct outcome
    By evenflowd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2021, 11:35 AM
  3. [SOLVED] Formula to choose outcome from series of options
    By archana89 in forum Excel General
    Replies: 6
    Last Post: 03-17-2019, 02:04 PM
  4. [SOLVED] Picking data based on more than one dropdown options
    By FrancisM2411 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-16-2016, 04:48 PM
  5. Picking a list people randomly & evenly over a period in a calendar
    By stringerbell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2016, 07:53 AM
  6. Random outcome generator based on Probability
    By randomraz in forum Excel General
    Replies: 5
    Last Post: 08-26-2015, 01:35 PM
  7. Number probability outcome
    By right_hand_of_doom in forum Excel General
    Replies: 4
    Last Post: 06-26-2009, 01:39 AM

Tags for this Thread

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