Categorical variables are a kind of information that may be divided into totally different classes. In Excel, there are a number of alternative ways to calculate categorical variables.
One option to calculate categorical variables is to make use of the COUNTIF operate. This operate counts the variety of cells that meet a sure standards. For instance, the next system would depend the variety of cells within the vary A1:A10 that include the worth “purple”:
