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

How to create large text containing numbers

I was creating a video on data analytics today. I needed to show a graphic of lots of data scrolling in the background for the video title. This is how I did it.

  • Create many rows of data by using this formula in Excel
    =RANDBETWEEN(1111111111111110,9999999999999990)
  • Copied the resulting data and pasted in Word as Text
  • Search for ^p which means paragraph mark and replace with nothing
  • This merged all the data into one big block of text
  • Paste it into a textbox in PowerPoint and use it for animation to create the title for the video

The result looks like this. Moral of the story? Use the right tool in the right place!

image