Excel: How to generate random data based upon known percentage distribution
Channel: Efficiency 365 by Dr Nitin
Date: 2015-12-13

If you know the market share of each product, create sample data containing the same proportion. Uses Discreet random number generation in Excel. Very useful for creating sample data for demos, workshops, training programs and simulations.

Dr. Nitin Paranjape (Office MVP)