This video will show you how to sort the frequency of one categorical variable by another – for example, if you want to see how the results of a survey question break down by the gender of the respondents.
We'll use some of the same formulas as for a regular frequency table (=UNIQUE, =COUNTIF, =SUM), as well as the =IF formula to make a "helper column" that will let us avoid the more complicated formulas.
We'll also quickly look at some bar graphs that we could make using this kind of table.