Categorical variables are a kind of information that may be divided into completely different classes. In Excel, there are just a few alternative ways to calculate categorical variables.
One method 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 method would rely the variety of cells within the vary A1:A10 that comprise the worth “purple”:
