Detailed instructions for use are in the User's Guide.
[. . . ] SPSS 12. 0 Brief Guide
®
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. [. . . ] With pivot tables, you can transpose rows and columns ("flip" the table), adjust the order of data in a table, and modify the table in many other ways. For example, you can change a short, wide table into a long, thin one by transposing rows and columns. Instead, it's a way to display your information in a different or more desirable manner.
E Double-click the Owns PDA * Gender * Internet Crosstabulation table.
94 Chapter 6 E If the Pivoting Trays window is not visible, from the menus choose: Pivot Pivoting Trays
Pivoting Trays provide a way to move data between columns, rows, and layers.
Figure 6-5 Pivoting Trays
95 Working with Output E Click one of the pivot icons to see what it represents. The shaded area in the table
indicates what will be moved when you move the pivot icon. A pop-up label also indicates what the icon represents in the table.
Figure 6-6 Pivot icon labels
E Drag the Statistics pivot icon from the Row dimension to the bottom of the Column
dimension. The table is immediately reconfigured to reflect your changes.
96 Chapter 6
The order of the pivot icons in a dimension reflects the order of the elements in the table.
Figure 6-7 Pivoting tray icon associations
E Drag the Owns PDA icon to the left of the Internet icon and release the mouse button
to reverse the order of these two rows
Creating and Displaying Layers
Layers can be useful for large tables with nested categories of information. By creating layers, you simplify the look of the table, making it easier to read. Layers work best when the table has at least three variables.
E Double-click the Owns PDA * Gender * Internet Crosstabulation table. E If the Pivoting Trays window is not visible, from the menus choose: Pivot Pivoting Trays
97 Working with Output E Drag the Gender pivot icon to the Layer dimension. Figure 6-8 Gender pivot icon in the Layer dimension
To view the different layers, you can either click the arrows on the layer pivot icon, or you can select a layer from the drop-down list in the table.
98 Chapter 6 Figure 6-9 Choosing a layer
Editing Tables
Unless you've taken the time to create a custom TableLook, pivot tables are created with standard formatting. Formats that you can change include font name, font size, font style (bold or italic), and color.
E Double-click the Level of education table. E If the Formatting toolbar is not visible, from the menus choose: View Toolbar E Click the title text, Level of education. E
From the drop-down list of font sizes on the toolbar, select 12.
99 Working with Output E To change the color of the title text, click the Text Color tool and select a color. Figure 6-10 Reformatted title text in the pivot table
You can also edit the contents of tables and labels. For example, you can change the title of this table.
E Double-click the title. E Type Education Level for the new label.
Note that if you change the values in a table, totals and other statistics are not recalculated.
100 Chapter 6
Hiding Rows and Columns
Some of the data displayed in a table may not be useful or it may unnecessarily complicate the table. Fortunately, you can hide entire rows or columns without losing any data.
E Double-click the Education Level table. E Ctrl-Alt-click on the Valid Percent column label to select all of the cells in that column. E Right-click the highlighted column and select Hide Category from the pop-up context
menu. To redisplay the column:
E From the menus choose: View Show All
Rows can be hidden and displayed in the same way as columns.
Changing Data Display Formats
You can easily change the display format of data in pivot tables.
E Double-click the Education Level table. E From the menus choose: Edit Select Data Cells
101 Working with Output E From the menus choose: Format Cell Properties E Type 0 in the Decimals field to hide all decimal points in this column. Figure 6-11 Cell Properties dialog box
You can also change the data type and format in this dialog box.
E
Select the type that you want from the Category list, and then select the format for that type in the Format list.
102 Chapter 6 E Click OK to apply your changes and return to the Viewer. [. . . ] In the Linear Regression dialog box, click Save to see a list of the new variables that you can add to your data file. If you generate any of these variables, they will not be available in a later session unless you save the data file.
Methods. If you have collected a large number of independent variables and want to
build a regression model that includes only variables that are statistically related to the dependent variable, you can select a method from the drop-down list. For example, if you select Stepwise in the above example, only variables that meet the criteria in the Linear Regression Options dialog box are entered in the equation.
Nonparametric Tests
The Nonparametric Tests submenu on the Analyze menu provides nonparametric tests for one sample or for two or more paired or independent samples. [. . . ]