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