User manual SPSS TABLES 11.5

[. . . ] SPSS Tables 11. 5 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. [. . . ] In the Pivot Table Labeling group, select Values and Labels from the Variable values in labels shown as drop-down list. Figure 7-15 Output labeling options Click OK to save this setting. 129 Summary Statistics Open the table builder (Analyze menu, Tables, Custom Tables) and click OK to create the table again. Figure 7-16 Values and labels displayed for variable categories The category values make it clear that a mean of 2. 34 is somewhere between Only some and Hardly any. Displaying the category values in the table makes it much easier to interpret the value of custom total summary statistics, such as the mean. This display setting is a global setting that affects all pivot table output from all procedures and persists across sessions until you change it. To change the setting back to display only value labels: From the menus, choose: Edit Options. . . In the Pivot Table Labeling group, select Labels from the Variable values in labels shown as drop-down list. Click OK to save this setting. Chapter 8 Summarizing Scale Variables A wide range of summary statistics are available for scale variables. In addition to the counts and percentages available for categorical variables, summary statistics for scale variables also include: n Mean n Median n Percentiles n Sum n Standard deviation n Range n Minimum and maximum values For more information, see "Summary Statistics for Scale Variables and Categorical Custom Totals" in the chapter Table Builder Interface. 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). 131 132 Chapter 8 Stacked Scale Variables You can summarize multiple scale variables in the same table by stacking them in the table. From the menus, choose: Analyze Tables Custom Tables. . . In the table builder, click Age of respondent in the variable list, Ctrl-click Highest year of school completed, and Ctrl-click Hours per day watching TV to select all three variables. Drag and drop the three selected variables to the Rows area of the canvas pane. Figure 8-1 Stacked scale variables in table builder 133 Summarizing Scale Variables The three variables are stacked in the row dimension. Since all three variables are scale variables, no categories are displayed, and the default summary statistic is the mean. Click OK to create the table. Figure 8-2 Table of mean values of stacked scale variables Multiple Summary Statistics By default, the mean is displayed for scale variables; however, you can choose other summary statistics for scale variables, and you can display more than one summary statistic. Open the table builder (Analyze menu, Tables, Custom Tables). Right-click any one of the three scale variables in the table preview on the canvas pane and select Summary Statistics from the pop-up context menu. In the Summary Statistics dialog box, select Median in the Statistics list and click the arrow to add it to the Display list. (You can use the arrow to move selected statistics from the Statistics list to the Display list, or you can drag and drop selected statistics from the Statistics list into the Display list. ) Click the Format cell for the median in the Display list and select nnnn from the drop- down list of formats. In the Decimals cell, type 1. Make the same changes for the mean in the Display list. 134 Chapter 8 Figure 8-3 Mean and median selected in Summary Statistics dialog box Click Apply to All to apply these changes to all three scale variables. Figure 8-4 Mean and median displayed in table of stacked scale variables Count, Valid N, and Missing Values It is often useful to display the number of cases used to compute summary statistics, such as the mean, and you might assume (not unreasonably) that the summary statistic Count would provide that information. However, this will not give you an accurate case base if there are any missing values. To obtain an accurate case base, use Valid N. Open the table builder (Analyze menu, Tables, Custom Tables). Right-click any one of the three scale variables in the table preview on the canvas pane and select Summary Statistics from the pop-up context menu. In the Summary Statistics dialog box, select Count in the Statistics list and click the arrow to add it to the Display list. 135 Summarizing Scale Variables Then select Valid N in the Statistics list and click the arrow to add it to the Display list. Click Apply to All to apply these changes to all three scale variables. Figure 8-5 Count versus Valid N For all three variable, Count is the same: 2, 832. [. . . ] ALL can be used to delete all sets; it is not enclosed in brackets. 236 MRSETS DISPLAY Subcommand /DISPLAY NAME= {[setlist]} {ALL } The DISPLAY subcommand creates a table of information about one or more sets. If one or more set names is given, the list must be enclosed in square brackets. ALL can be used to refer to all sets; it is not enclosed in brackets. Appendix TABLES Command Syntax Converter If you have command syntax files that contain TABLES syntax that you want to convert to CTABLES syntax, a simple utility program is provided to help you get started with the conversion process. There are, however, significant differences between TABLES and CTABLES functionality, and it is likely that you will find that the utility program cannot convert some of your TABLES syntax jobs or may generate CTABLES syntax that produces tables that do not closely resemble the original tables produced by the TABLES command. [. . . ]