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.

SharePoint Part 13 – Field Staff Management

Share data from Head Office to field staff or vice versa. All using the powerful List feature of SharePoint. Zero Programming. Anyone can do it in minutes. Try it and apply it to your needs.

These videos were created in 2013. Therefore the logos and screenshots depict older versions of products. However the concepts – which are more important – are still valid.