User manual SPSS TABLES 13.0

[. . . ] SPSS Tables 13. 0 TM For more information about SPSS® software products, please visit our Web site at http://www. spss. com or contact SPSS Inc. 233 South Wacker Drive, 11th Floor Chicago, IL 60606-6412 Tel: (312) 651-3000 Fax: (312) 651-3668 SPSS is a registered trademark and the other product names are the trademarks of SPSS Inc. No material describing such software may be produced or distributed without the written permission of the owners of the trademark and license rights in the software and the copyrights in the published materials. The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. [. . . ] The default selection is Show each category as a layer. This is equivalent to stacking. E Click OK to create the table. E Double-click the table in the Viewer window to activate it. E Click the down arrow on the drop-down list to display the whole list of layers. 95 Stacking, Nesting, and Layers with Categorical Variables Figure 4-20 List of stacked layers in activated pivot table There are seven layers in the table: two layers for the two Gender categories and five layers for the five Highest degree categories. For stacked layers, the total number of layers is the sum of the number of categories for the layer variables (including any total or subtotal categories you have requested for the layer variables). Two Nested Categorical Layer Variables Nesting categorical layer variables creates a separate layer for each combination of layer variable categories. E Open the table builder (Analyze menu, Tables, Custom Tables). E If you haven't done so already, follow the directions above for creating a table of stacked layers. E In the Layer Output group, select Show each combination of categories as a layer. This is equivalent to nesting. E Click OK to create the table. E Double-click the table in the Viewer window to activate it. E Click the down arrow on the drop-down list to display the whole list of layers. 96 Chapter 4 Figure 4-21 List of nested layers in activated pivot table There are 10 layers in the table (you have to scroll through the list to see all of them), one for each combination of Gender and Highest degree. For nested layers, the total number of layers is the product of the number of categories for each layer variable (in this example, 5 x 2 = 10). Printing Layered Tables By default, only the currently visible layer is printed. To print all layers of a table: E Double-click the table in the Viewer window to activate it. E From the Viewer window menus, choose: Format Table Properties. . . E Select Print all layers. You can also save this setting as part of a TableLook, including the default TableLook. Chapter Totals and Subtotals for Categorical Variables 5 You can include both totals and subtotals in custom tables. Totals and subtotals can be applied to categorical variables at any nesting level in any dimension--row, column, or layer. Sample Data File The examples in this chapter use the data file survey_sample. sav. This file is located in the Tutorial\sample_files folder within the folder in which SPSS is installed. All examples provided here display variable labels in dialog boxes, sorted in alphabetical order. Variable list display properties are set on the General tab in the Options dialog box (Edit menu, Options). Simple Total for a Single Variable E From the menus, choose: Analyze Tables Custom Tables. . . E In the table builder, drag and drop Age category from the variable list to the Rows area on the canvas pane. E Right-click on Age category on the canvas pane and select Summary Statistics from the pop-up context menu. E In the Summary Statistics dialog box, select Column N % in the Statistics list and click the arrow to add it to the Display list. 97 98 Chapter 5 E In the Label cell in the Display list, delete the default label and type Percent. E Right-click on Age category on the canvas pane and select Categories and Totals from the pop-up context menu. E Select (click) Total in the Categories and Totals dialog box. Figure 5-1 Categories and Totals dialog box E Click Apply and then click OK in the table builder to create the table. 99 Totals and Subtotals for Categorical Variables Figure 5-2 Simple total for a single categorical variable What You See Is What Gets Totaled Totals are based on categories displayed in the table. If you choose to exclude some categories from a table, cases from those categories are not included in total calculations. E Open the table builder (Analyze menu, Tables, Custom Tables). E Right-click on Age category on the canvas pane and select Categories and Totals from the pop-up context menu. E Click the category labeled Less than 25 in the Label list. E Click the arrow key to the left of the Exclude list. [. . . ] Convert only TABLES commands in the syntax file. Other commands in the file are not altered. Retain the original TABLES syntax in commented form. Identify the beginning and end of each conversion block with comments. [. . . ]