Hi,
I would like to generate biased data in Excel. For example, I have 100 lines of total data. 60 of those represent company A, 30 represent company B, and 10 represent company C. The data should look something like in the attached Excel file.
I want company A's work done to be 1 80% of the time, company B's 65% of the time and company C's 70% of the time.
The best I have till now is =LOOKUP(RAND();{0;0,2};{0;1}) which generates 1 80% of the time (and I use it for company A), but this works on a cell level.
How can I make sure that the number of 1s generated (for the work done column) for all the 60 lines of company A averages to 80% and so on so forth for companies B and C?
Bookmarks