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.

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST