There are plenty of terrific random data generators for Excel out there. But sometimes you just need some fake data qualitative data without the fuss.
For instance, perhaps I want to generate a random list of data points with the values low, medium, or high. A simple method I recommend combines RANDBETWEEN with CHOOSE. Take a look:
=CHOOSE(RANDBETWEEN(1,3), “low”, “medium”, “high”)
All I would need to do now is use the formula above and then drag down to create a list of random, qualitative data.
If I want more weight given to a certain variable, say I want low to appear 50% of the time, I can adjust the bounds of my RANDBETWEEN and repeat the data item.
=CHOOSE(RANDBETWEEN(1,4), “low”, “low”, “medium”, “high”)
It’s not the most elegant solution, I admit. But like I said, it does well in a pinch.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.