Results 1 to 2 of 2

Random number based on probability of and array 3x3

Threaded View

frapi060 Random number based on... 02-11-2019, 10:11 AM
Special-K Re: Random number based on... 02-11-2019, 11:21 AM
  1. #1
    Registered User
    Join Date
    11-15-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    12

    Random number based on probability of and array 3x3

    Hi,

    I have 4 types of products (Lite, Pro, AI), and probabilities for each rage of number of products (1-9, 10-49, 50-100). I would like to generate a set of 1.000 random numbers following the information of the 3x3 matrix. Does anyone know how to do this? The data analysis tool based on probabilities is not working with matrices and cannot figure out how to solve this.



    Thanks
    Attached Files Attached Files
    Last edited by frapi060; 02-11-2019 at 10:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generating Random Number with Probability
    By ixander in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-24-2016, 12:13 PM
  2. Generating random outcomes based on probability
    By JP2008 in forum Excel General
    Replies: 9
    Last Post: 12-07-2015, 04:48 AM
  3. Random outcome generator based on Probability
    By randomraz in forum Excel General
    Replies: 5
    Last Post: 08-26-2015, 01:35 PM
  4. [SOLVED] Generate random number from probability
    By shinzai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2013, 11:53 AM
  5. Need Random Number Generator but with Weighted Probability for Certain Numbers...
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-13-2012, 03:52 PM
  6. Need Help with a Random Number Generator with Weighted Probability for Certain Numbers
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2012, 02:48 PM
  7. Return random number based on probability
    By gazza365 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2011, 08:46 PM

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