3 ms·
1. If the number of choices is small i.e., in the order of 10 to 20, write them in slips of paper and throw them in a bowl, mix them and pull one out. 2. If th
by vivegi 4y ago
1. If the number of choices is small i.e., in the order of 10 to 20, write them in slips of paper and throw them in a bowl, mix them and pull one out.
2. If the number of choices is medium i.e., in the order of 100s, write them down in Excel and number them sequentially. Then use the RANDBETWEEN() function to select the choice.
3. If the number of choices is very large i.e., neither small nor medium, use a database table instead of Excel (mentioned in step 2) and implement the same logic (in dbquery + code).
4. If your choice does not necessarily have to be random, but achieve group consensus between a number of individuals (that fit in a conference room), use a technique like multi-voting [See: https://asq.org/quality-resources/multivoting https://asq.org/quality-resources/multivoting]