How to Find a Qualitative Variable in Excel. Quantitative variables take the form of numerical figures. Qualitative variables describe data by placing them into broad categories.