User manual SPSS TABLES 14.0

[. . . ] SPSS Tables 14. 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. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subdivision (c) (1) (ii) of The Rights in Technical Data and Computer Software clause at 52. 227-7013. [. . . ] 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 Age category on the canvas pane and choose 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. E In the Label cell in the Display list, delete the default label and type Percent. E Right-click Age category on the canvas pane and choose 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. Figure 5-2 Simple total for a single categorical variable 97 Totals and Subtotals for Categorical Variables 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 Age category on the canvas pane and choose 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 again. The two categories are moved from the Display list to the Exclude list. Figure 5-3 Manually excluded categories 98 Chapter 5 E Click Apply and then click OK in the table builder to create the table. Figure 5-4 Total in table with excluded categories The total count in this table is only 2, 107, compared to 2, 828 when all of the categories are included. Only the categories that are used in the table are included in the total. (The percentage total is still 100% because all of the percentages are based on the total number of cases used in the table, not the total number of cases in the data file. ) Display Position of Totals By default, totals are displayed below the categories being totaled. You can change the display position of totals to show them above the categories being totaled. E Open the table builder (Analyze menu, Tables, Custom Tables). E Right-click Age category on the canvas pane and choose Categories and Totals from the pop-up context menu. E In the Totals and Subgroups Appear group, select Above. E Click Apply and then click OK in the table builder to create the table. Figure 5-5 Total displayed above totaled categories Totals for Nested Tables Since totals can be applied to categorical variables at any level of the nesting, you can create tables that contain group totals at multiple nesting levels. 99 Totals and Subtotals for Categorical Variables Group Totals Totals for categorical variables nested within other categorical variables represent group totals. E Open the table builder (Analyze menu, Tables, Custom Tables). E Drag and drop Gender to the left of Age category on the canvas pane. E Right-click Age category on the canvas pane and choose Categories and Totals from the pop-up context menu. Before creating the table, let's move the totals back below the totaled categories. E In the Totals and Subgroups Appear group, select Below. Figure 5-6 Age category nested within Gender in the table builder E Click OK to create the table. 100 Chapter 5 Figure 5-7 Age category totals within Gender categories The table now displays two group totals: one for males and one for females. Grand Totals Totals applied to nested variables are always group totals, not grand totals. If you want totals for the entire table, you can apply totals to the variable at the outermost nesting level. E Open the table builder again (Analyze menu, Tables, Custom Tables). E Right-click Gender on the canvas pane and choose Categories and Totals from the pop-up context menu. E Select (click) Total in the Categories and Totals dialog box. [. . . ] If you go back to the original 209 Formatting and Customizing Tables table with just the two categorical variables, you will see that there are, in fact, three cases in this crosstabulated category. There are no valid cases, however, because all three have missing values for the scale variable Hours per day watching TV. Changing the Default TableLook Many of the display properties of pivot tables can be controlled with TableLooks. A wide variety of predefined TableLooks are available, and you can control the default TableLook that determines the display properties applied to pivot tables when they are created. E From the menus, choose: Edit Options. . . Figure 12-14 Changing the default TableLook E Click OK. 210 Chapter 12 E Open the table builder (Analyze menu, Tables, Custom Tables). [. . . ]