I want to use the market share values of their products to generate the sample data. Here is how you do it. Watch 3.5 minute video. https://efficiency365.com/2016/01/08/how-to-generate-random-data-based-upon-known-percentage-distribution-using-excel/
