IBM SPSS Statistics is an integrated family of products that addresses the entire analytical process, from planning to data collection to analysis, reporting and deployment. With more than a dozen fully integrated modules to choose from, you can find the specialized capabilities you need to increase revenue, outperform competitors, conduct research and make better decisions.
The following passage explains the concept of Tables for Variables with Shared Categories. If you would like to know more about training courses, visit the IBM Training Course Catalog.
The IBM SPSS Statistics Custom Tables Module allows you to have a lot of control over how you build and edit your pivot tables. One very useful table you can build within the Custom Tables Module is a table for variables with shared categories. For example, it is very common for surveys to ask a series of questions that are rated on the same scale (e.g., seven point scale that ranges from Strongly Disagree to Strongly Agree). Normally if you want to build a table for this type of variable, your table will look something like this.
You can then create multiple tables like the above table so that you can compare the distributions of several variables. However, within the Custom Tables Module you can display the distributions of several variables simultaneously, so that you can easily compare across variables (see table below).
Now for example, you can easily see that there are not very many ratings of “Very good” for the services staff compared to the other two staff types. To create the above table, you need to use the Custom Tables Module and you need to ensure that all the variables you put in the table share the same response categories (e.g., seven point scale that ranges from Strongly Disagree to Strongly Agree). Once in the Custom Tables Module, you need to place your variables in the row dimension onto the canvas and change the category position (in the lower right hand corner of the Custom Tables Module) from “default” over to “row labels in column” (see arrow).
Follow @basupp on Twitter for updates, news, articles and videos related to Business Analytics Support.