fbpx

How to generate random data with known percentage distribution

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.

[youtube https://www.youtube.com/watch?v=igxYef7USl8?rel=0]

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list