Social Sciences Research and Instructional Council
Teaching Resources Depository

SPSS for Windows, Version 9.0: A Brief Tutorial
(Hypertext Version)

Appendix D: Making it Look Nice
Using Your Word Processor
And Other Ways To Make Your Results Look Nice

© The Authors, 2000; Last modified 26 January 2000

Bringing SPSS Output Into Your Word Processor

This appendix will describe only the simplest way of copying SPSS output into your word processor. The Output Window is divided into two vertical frames or panes. The left-hand pane contains the outline of the output or information that SPSS gives you. This information is in outline form and can be used to select what you want to view. Simply click on the information you want to look at and that information will appear in the right-hand pane. You can also collapse the outline by clicking on the plus and minus signs in the left-hand pane. The plus sign indicates that the information is collapsed (or hidden) and the minus sign indicates that it is expanded (or shown). You can use the scroll bars on each pane to scroll through the Output Window.

Let's use the General Social Survey to get the crosstabulation of ABANY and SEX. Open the General Social Survey data set (GSS98A) and click on "Analyze" and then point your mouse at "Descriptive Statistics" and click on "Crosstabs." Put ABANY in the row box and SEX in the column box. Now click on "Cells" and select column percents and then click on "Continue." Finally, click on "Statistics" and select chi square and then click on "Continue" and then click on "OK." The Output Window should appear and your screen should look like Figure D-1.

Figure D-1
Figure D-1

The left-hand pane will contain an outline of the tables in the right-hand pane. Click on "Abortion--For Any Reason" and this will select that table in the right-hand pane. Your screen should look like Figure D-2.

Figure D-2
Figure D-2

The red arrow to the left of the table indicates that it has been selected. Put your mouse pointer anywhere inside this table and double click. The border of the table will change and it will have a series of cross-hatches on it. You can now edit the table. Let's say you want to change the title. Point your mouse at the title and click once. This will place a thick border around the title (see Figure D-3).

Figure D-3
Figure D-3

Press the function key, "F2." The title will be highlighted and you can edit it. When the title is highlighted, typing something will replace the original title with whatever you type. If you only want to change part of the title, click again where you want to make the change. Press "Return" to accept the change and "Escape" to restore the original title. The easiest thing to do is to make your changes in the Output Window before you copy the table to your word processor.

Now that you have made your changes, let's copy it to a word processor. Make sure the table is selected and click on "Edit" and then on "Copy." This will copy the table to the clipboard. Now open your word processor and click on "Paste Special." You will be asked if you want to paste it as a picture or as unformatted text. Since you have made all your editing changes, paste it as a picture. Since it is pasted as a picture, you will only be able to resize it but not to edit its contents. You can paste charts and graphs using the same procedure.

There are other ways to accomplish this, but these procedures are the simplest and will work in both Word and WordPerfect.

Changing the Look of SPSS Tables

You can make your tables take on a new look if you like. Go to Edit, Options, and then click the "Pivot Tables" tab you will find choices for how your tables will appear. Many of us prefer the "Academic 2.tlo" for table presentation since it looks much like tables in professional journals.

Formatting Your Frequencies

To make "Format" choices for your frequencies output click the "Format" button on the main frequencies dialog box (Figure 4-2), and a dialog box of format choices, Figure D-4, will appear.

Figure D-4
Figure D-4

Changing Your SPSS Charts

SPSS provides extensive editing possibilities for charts. These for the most part are beyond the scope of this text. As an example we will perform some simple editing tasks on a chart for the variable RACE, "RACE OF RESPONDENT" created with the "Frequencies" function in "Descriptive Statistics." The first step is to double click on the chart in the output window and a chart editing window with our chart will open, Figure D-5.

Figure D-5
Figure D-5

We can change the chart type by selecting a different type of chart in the "Gallery" menu. I choose a "Pie" chart (which is also appropriate for this categorical data) then clicked the "Replace" button, leaving the "Simple" default selection, in the dialog box that opens, Figure D-6.

Figure D-6
Figure D-6

To change text for labels double click on the label you want to change. I double clicked on the chart title. A text editing window will open for editing the title. As can be seen in Figure D-7, I added text in "Title 2," left everything else the same and clicked the "OK" button.

Figure D-7
Figure D-7

A similar process of clicking a label for pie slices allows you to select the the type of labels for the pie slices text labels, values or percents. To change the pattern and colors for bars in a bar chart (all bars have the same color) or slices in a pie chart, click the pie slice (or bars) you want to change, then choose the pattern or color you want in the dialog box that appears (only one dialog box "Colors" or the "Fill Pattern" will appear not both as in Figure D-8.) Click the "Apply" button to make the changes in your chart.

Figure D-8
Figure D-8

To add an annotation such as the percentage for each bar on a bar chart, double click the bar chart to bring it into the chart editing window. Click the "Chart" menu and choose "Annotation," Figure D-9. In the dialog window that appears click the category, "WHITE" for this variable, place the text you want in the "Text" box (79%), choose "Justification ("Center"), click the "Add" Button. Click "OK" to make the changes.

Figure D-9
Figure D-9

I did this for each category, typing in the per cent for that category with Figure D-10 as the final result.

Figure D-10
Figure D-10

Back
Top
Previous Appendix
SPSS Book Table of Contents
Home