How to generate random data based upon known percentage distribution using Excel

Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data to look familiar to the participants. I want to use the names of their products in sample data containing 1000 rows. I could use Randbetween() with Vlookup but that gives me almost equal distribution for all products. I want to make the data look realistic. I want to use the market share values of their products to generate the sample data. Here is how you do it. 3.5 minute video.

Quality Management: Knowledge Pack

Here is a list of all articles related to the seven Quality Management Tools. From Run Chart to Flow chart, from scatter chart to Pareto chart.

Quality Management Tools - List of articles

  1. Quality Management 1. Fishbone (Cause and Effect) Diagram
  2. Quality Management 2. Check Sheet
  3. Quality Management 3: Run Charts
  4. Quality Management 4: Histograms (any version of Excel)
  5. Quality Management 4: Histogram using Pivot Table
  6. Quality Management 4: Histogram (using Excel 2016)
  7. Quality Management 5: Pareto Chart
  8. Quality Management 5: Histogram and Pareto
  9. Quality Management 6: Scatter Diagram
  10. Quality Management 7 – Flowcharts