+ Reply to Thread
Results 1 to 1 of 1

Generating random numbers from a range, based on probability defined by parameter.

  1. #1
    Registered User
    Join Date
    04-20-2013
    Location
    europe
    MS-Off Ver
    Excel 2016
    Posts
    12

    Generating random numbers from a range, based on probability defined by parameter.

    The source of the numbers is column A. Column B is the amount of each of these numbers.
    The top x % (I want this as the parameter) sets the range from which I want random numbers, it is the top x % of the sum of the amount. In this case 191,166 and 164 is the top 25% of the total sum of amount values.

    Based on this, I want 50, 15 and 6 randomly generated with 37%, 32%, 31% probability. By changing the top % value to 50%, I want 50,15,6,17,65,75 randomly generated with 20%, 17%, 17%, 16%, 16%, 14% probability, and so on.

    Without using macros, if possible.

    excel 1.jpg
    Last edited by szasz; 04-20-2013 at 09:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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