A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
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.
Get the FREE Excel Power User Guide