Categorical variables are a kind of knowledge that may be divided into completely different classes. In Excel, there are a couple of alternative ways to calculate categorical variables.
One approach to calculate categorical variables is to make use of the COUNTIF perform. This perform counts the variety of cells that meet a sure standards. For instance, the next formulation would depend the variety of cells within the vary A1:A10 that include the worth “pink”:
