Cross tabulation is usually performed on categorical data — data that can be divided into mutually exclusive groups. In other words, categorical data is data or variables that are separated into different categories that are mutually exclusive from one another. 

An example of categorical data is the region of sales for a product. Typically, region can be divided into categories such as geographic area (North, South, Northeast, West, etc) or state (Pahang, Perak, Selangor, etc). The important thing to remember about categorical data is that a categorical data point cannot belong to more than one category.

Cross tabulation is especially useful for survey responses especially for demographic data. It can be done with tools such as Microsoft Excel, SPSS, and SAS. 

Exercise 1 

Please download the data here.

Exercise 2 

Please download the data here.