To delete an object select it then press delete to

This preview shows page 92 - 95 out of 150 pages.

To delete an object, select it then press delete.To move an object, select it and move it to desired place.A selected object can be copied by either in editcopy, ctrl+c or rightclickcopy.Doubleclicking on tables activates the edit mode or opens the pivot table interface.PIVOTTABLESPivot tables allow users to interactively rearrange the rows, columns and layers in the table. More thanthat, the pivot table interface also includes table editing and formatting commands.In order to open the pivot table interface, doubleclick on a table in the output pane in the output viewer.The Pivot table dialog box will appear:Figure 102 The Pivot Table InterfaceThe Pivot Table ins SPSS can perform various tasks:i.Transpose rows and columnsii.Moving rows and columnsiii.Create layersiv.Grouping/Ungrouping rows and columnsv.Show/Hide cellsvi.Changing orientation of row and column labelsvii.Editing Text in a Tableviii.Table Formatting
Course Notes in Statistical Softwares 86|D a q u i sTranspose Rows and ColumnsOn the pivot table interface, choose Pivot/Transpose rows and columns. This command simplytransposes the table. For example, the original table is this:Table 101 Transposed TableMoving Rows and ColumnsIn order to move rows and columns or create layers, thePivoting TraysWindow should be open. If thePivoting Trayswindow does not show up, click PivotPivoting Trays. The pivoting trays window will be displayed:Figure 103 The Pivoting Trays WindowTo move a row or a column, click on any of the entry in the row or column and drag it onto another place.For example, if you want to have a crosstabulation withmarital statusas columns divided intogender, click anddrag the variable labelmarital statusand drop it right above the variable labelgender, making the followingchange (crosstabs cropped):
Course Notes in Statistical Softwares 87|D a q u i sYields the following pivot transformation:Table 102 Rearranged TableCreating LayersCreating layers is just the very same process as moving columns and rows. Open thePivoting Trayswindow (again, click PivotPivoting Trays) then click on a variable and to drag and drop it on theLayerfield. Theresulting crosstab will be divided into layers, the visible table is the table of the top layer. To change a layer, selecta category from a dropdown list of layers:Table 103 Selecting a LayerRotate Pivot LabelsTo rotate pivot labels, Click FormatRotate Inner Column Labels or Rotate Outer Row Labels.Table 104 Rotated Outer Row and Inner Column LabelsEdit Text and Formatting TablesTo edit a text, go to table edit mode or open the pivot table and then double click on the entry you wantto edit. Caution: Editing is not just restricted to editing category names, but also eding the data themselves! Toformat a cell, click on a particular cell (note that every part of the table is a cell, including the title, then ClickFormat/RightClickCell Properties. The cell properties dialog box will open:

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture