Weighted Probabilities with random numbers
Results 1 to 5 of 5

Thread: Weighted Probabilities with random numbers
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Weighted Probabilities with random numbers

    Hi guys, this has been killing me but does anyone know how to incorporate weighted probabilities with random numbers? For example:

    I need to have a random number between 1-9 and have these probabilities:
    1 5%
    2 10%
    3 0%
    4 20%
    5 30%
    6 10%
    7 10%
    8 10%
    9 5%

    Any help would be much appreciated!

    I just need a formula please and thank you.

  2. #2
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,602
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Weighted Probabilities with random numbers

    Welcome to the board.

    =match(rand(), {0;5;15;15;35;65;75;85;95}%)

  3. #3
    New Member
    Join Date
    Mar 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Weighted Probabilities with random numbers

    Thank you so much!

  4. #4
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,602
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Weighted Probabilities with random numbers

    You're welcome.

  5. #5
    Board Regular
    Join Date
    Nov 2005
    Location
    UK
    Posts
    209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Weighted Probabilities with random numbers

    Quote Originally Posted by shg View Post
    Welcome to the board.

    =match(rand(), {0;5;15;15;35;65;75;85;95}%)
    Hi shg - how does this work?

    Not being a mathematician, I can't see immediately the relationship between the percentages senx7810 wanted and the number you put in the curly brackets.

    Thanks
    Win10, Excel 2016 64Bit, UK

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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