Technical learning is Here

Guide to SPSS

Overview

IBM SPSS Statistics is software for managing data and calculating a wide variety of statistics. This document is intended for students taking classes that use SPSS Statistics or anyone else who is totally new to the SPSS software. Those who plan on doing more involved research projects using SPSS should follow up this brief intro with more in-depth training.

For information about SSCC lab accounts, the labs, Winstat and more see Information for SSCC Instructional Lab Users.

The SPSS software is built around the SPSS programming language. The good news for beginners is that you can accomplish most basic data analysis through menus and dialog boxes without having to actually learn the SPSS language. Menus and dialog boxes are useful because they give you visual reminders of (most of) your options with each step of your analysis. However, some tasks cannot be accomplished from the menus, and others are more quickly carried out by typing a few key words than by working through a long series of menus and dialogs. As a beginner, it will be strategic to learn a bit of both SPSS programming and the menus.

In the long run, you will want to learn to just work directly in the programming language, because this is how you document your work, and good documentation is key to both trouble-shooting and replicating complicated projects. For now, we assume you are just carrying out very simple tasks.

Part two discusses common statistics, regression, and graphs.

Starting SPSS Statistics
The SSCC has SPSS installed in our computer labs (4218 and 3218 Sewell Social Sciences Building) and on some of the Winstats. If you work on a University-owned computer you can also go to DoIT's Campus Software Library, and download and install SPSS on that computer (this requires a NetID, and administrator priviledges).

To run SPSS, log in and click Start - Programs - IBM SPSS Statistics - IBM SPSS Statistics 23.

When SPSS is first started you are presented with a dialog box asking you to open a file. Pick a recently opened file or pick "Open another file" from the list on the left.

Typically you start your SPSS session by opening the data file that you need to work with.

The SPSS Windows and Files
SPSS Statistics has three main windows, plus a menu bar at the top. These allow you to (1) see your data, (2) see your statistical output, and (3) see any programming commands you have written. Each window corresponds to a separate type of SPSS file.

Data Editor (.sav files)

The Data Editor lets you see and manipulate your data. You will always have at least one Data Editor open (even if you have not yet opened a data set). When you open an SPSS data file, what you see is a working copy of your data. Changes you make to your data are not permanent until you save them (click File - Save or Save As). Data files are saved with a file type of .save, a file type that most other software cannot work with. When you close your last Data Editor you are shutting down SPSS and you will be prompted to save all unsaved files.

To open a different data set, click File - Open - Data. (It is also possible to open some non-SPSS data files by this method, such as Excel, Stata, or SAS files.) SPSS lets you have many data sets open simultaneously, and the data set that you are currently working with, the active data set, is always marked with a tiny red "plus" sign on the title bar. In order to avoid confusion it is usually a good strategy to close out any Data Editors you're done using.

Output Viewer (.spv files)

As you ask SPSS to carry out various computations and other tasks, the results can show up in a variety of places. New data values will show up in the Data Editor. Statistical results will show up in the Output Viewer.

The Output Viewer shows you tables of statistical output and any graphs you create. By default it also show you the programming language for the commands that you issued (called syntax in SPSS jargon), and most error messages will also appear here. The Output Viewer also allows you to edit and print your results. The tables of the Output Viewer are saved (click File - Save or Save As) with a file type of .spv, which can only be opened with SPSS software.

As with Data Editors, it is possible to open more than one Output Viewer to look at more than one output file. The active Viewer, marked with a tiny blue plus sign, will receive the results of any commands that you issue. If you close all the Output Viewers and then issue a new command, a fresh Output Viewer is started.

Syntax Editor (.sps files)

If you are working with the SPSS programming language directly, you will also open a Syntax Editor.

The Syntax Editor allows you to write, edit, and run commands in the SPSS programming language. If you are also using the menus and dialog boxes, the Paste button automatically writes the syntax for the command you have specified into the active Syntax Editor. These files are saved as plain text and almost any text editor can open them, but with a file extension of .sps.

As with the other types of windows, you can have more than one Syntax Editor open and the active window is marked with a tiny orange plus sign. When you paste syntax from dialog boxes, it goes to the active Syntax Editor. If you close out all your Syntax Editors and then paste a command, a fresh Syntax Editor is opened.

Issuing Commands
Unless you command SPSS to do something, it just sits there looking at you. In general commands may be issued either through menus and dialog boxes that invoke the programming language behind the scenes, or by typing the programming language in a Syntax Editor and running the commands.

Dialog Boxes
Although each dialog box is unique, they have many common features. A fairly typical example is the dialog box for producing frequency tables (tables with counts and percents). To bring up this dialog box from the menus, click on Analyze - Descriptive Statistics - Frequencies.

On the left is a variable selection list with all of the variables in your data set. If your variables have variable labels, what you see is the beginning of the variable label. To see the full label as well as the variable name [in square brackets], hold your cursor over the label beginning. Select the variables you want to analyze by clicking on them (you may have to scroll through the list). Then click the arrow button to the right of the selection list, and the variables are moved to the analysis list on the right. If you change your mind about a variable, you can select it in the list on the right and then click the arrow button to move it back out of the analysis list. On the far right of the dialog are several buttons that lead to further dialog boxes with options for the frequencies command. At the bottom of the dialog box, click OK to issue your command to SPSS, or Paste to have the command written to a Syntax Editor.

If you return to a dialog box you will find it opens with all the specifications you last used. This can be handy if you are trying a number of variations on your analysis, or if you are debugging something. If you'd prefer to start fresh you can click the Reset button.

Working with the Data Editor
The main use of the Data Editor is to show you (a portion of) the data values you are working with. It can also be used to redefine the characteristics of variables (change the type, add labels, define missing values, etc.), create new variables, and enter data by hand.

The Data Editor gives you two views of your data set: a Data View and a Variable View, selected by clicking on the appropriate tab in the lower left corner of the window.

In the Data View, the data are laid out in the standard rectangular format for statistical software. Each row represents a unit of observation, sometimes also referred to as a record or in SPSS as a case. The case (observation) number in the leftmost column is assigned automatically and is not saved as data. Each column represents a variable. All of the data in a column must be of the same type, either numeric or string (also called character).

Each data cell holds a data value. If data are missing, they are displayed as a period (".") or as a blank (" "). Data values may be displayed as either the actual value or as a formatted value. For example, a data value about a person's income might be 15000, while its formatted value might be shown as $15,000. Formats can also take the form of value labels, for instance, data recorded as 1's and 2's might be labeled as "Male" and "Female." While formatting makes it easier to interpret results, it is important to remember that the data values are what SPSS actually processes. In particular, when you set up a command that requires you to specify one or more data values, you use values and not formatted values.

You can switch the Data View between formatted and unformatted data by clicking on the Value Labels button on the Toolbar, the fourth button from the right when in the Data View. With value labels on you can also see the actual values for a given variable by clicking on a cell and then looking at the bar just above the data. The box to the left indicates the observation number and variable selected, e.g. 1:gender, while the center box shows you the actual value, e.g. m.

Data values can be edited or added by typing them directly into the Data View. To enter data, type in the actual data value. However, aside from very small data sets for class exercises, you should almost never need to do this.

Variable View
In the Variable View you can see and edit the information that defines each variable (sometimes called meta-data) in your data set: each column of the Data View is described by a row of the Variable View.

The first attribute of each variable is its Name. The variable name is how the data column is identified in the programming language, and in order for the programming language to work gracefully variable names have to abide by certain restrictions: names must begin with a letter, and may be made up of characters, numerals, non-punctuation characters, and the period. Capitalization is ignored. Variable names may be up to 64 characters long. Other restrictions may apply - no coupons please. Variable names may be added or changed simply by typing them in.

The basic variable types are either numeric or string. However, just to make things confusing, SPSS allows you to select among several different standard formats for displaying numeric data (e.g. scientific notation, comma formatting, currencies) and calls this Type. You set the variable type by clicking in the column, then clicking on the gray button that appears and working in a dialog box.

The Label attribute allows you to give each variable a longer description that is displayed in place of the variable name, analogous to value labels for data values. Both variable labels and value labels are useful for giving you more intelligible output.

The Values attribute allows you to create a list of value labels. Often several variables will share a common set of value labels, and in this window you can copy and paste value label sets. Variable labels are set by simply typing them in, value labels work through a dialog box.

The Missing attribute is a place for you to designate certain data values that you want SPSS to ignore when it calculates statistics. For instance, in survey data it is common practice to record a data value of 8 when a respondent says "I don't know" in response to a question, and you can have SPSS treat the 8's in a variable as if they were missing data.

The other attributes, Width, Decimals, Columns, Align, Measure, and Role, are minor settings related to data display. Although Measure (level of measurement) is statistically a very important concept, it has little meaning within the SPSS software.

Working with the Output Viewer
The Output Viewer collects your statistical tables and graphs, and gives you the opportunity to edit them before you save or print them. The Output Viewer is divided into two main sections, an outline pane on the left, and a tables pane on the right. When you print your output, it is the tables pane that is printed.

When SPSS creates output (tables, syntax, error messages, etc.) it adds them to the tables pane as objects, and each object is noted in the outline pane. Individual objects may be opened and edited, deleted, hidden, rearranged, or printed. To select an object to work with, you can either click on it in the tables pane, or click on the corresponding entry in the outline pane. A red arrow appears next to the object in both panes.

To edit objects, double-click on them in the tables pane. Depending on whether you are trying to edit a simple object like a title (which is just a box with some text in it), or something more complicated like a table or a graph, you may be able to simply change the object in the Output Viewer, or another window may open. Except for editing the look of graphs, it will often be easier to edit your output by exporting it to Microsoft Word first, but in principle you can change anything you can see in your output, down to deleting columns and changing numbers. (But if your intent is to fake your results, you should attend our Simulations workshop for better methods of doing this.)

To delete objects, select them in either pane and use the Delete key.

To hide objects, double-click on the icon for each object in the outline pane. To make them visible, just double-click again. You can hide a whole section of the outline by clicking on the minus sign to the left of the group in the outline pane. Hidden objects are not printed, but are saved with the output file.

To rearrange objects, select the object (or group of objects) in either pane, and drag them until the red arrow points to the object below which you want them to appear.

To export your output, you go through a special procedure. In the Output Viewer click File - Export to invoke the Export dialog box. There are three main settings to look at. First, pick the type of file to which you want to export: useful file types include Excel, PDF, PowerPoint, or Word. Next, check that you are exporting as much of your output as you want, the Objects to Export at the top of the dialog. If you have a part of your output selected, this option will default to exporting just your selection, otherwise you typically will export all your visible output. Finally, change the default file name to something meaningful, and save your file to a location where you will be able to keep it, like your U:\ drive.

Once your options are set, click OK

.

Working with the Syntax Editor

Learning SPSS programming syntax is a separate topic; the fundamentals are addressed in our SSCC training workshops. But you don't have to memorize a whole new language in order to paste and run SPSS syntax.
The fundamental unit of work in the SPSS language is the command: think of commands as analogous to well-formed sentences. In this language, commands begin with a keyword and end with a period. Commands should begin in the leftmost column in the editor. If they are wrapped onto more than one line, the continuing lines should begin with a blank space. Capitalization does not matter. The Syntax Editor displays syntax that SPSS cannot interpret in red type.

Like the Output Editor, the Syntax Editor has two panes. The tables pane on the right is what is actually saved in the .sps file.

Running syntax. To have SPSS actually carry out your command(s), you must run them. Click Run, and then one of the menu options. There is also an icon on the Toolbar to run your program, a right-facing triangle ("play"). You can run all the commands in the editor, or select a group of commands and run just that (be careful that you highlight full commands, from the first keyword through the final period). You can also run the current command, which is whatever command the cursor is located within.

Pasting and running. From most dialog boxes you have the option of pasting commands instead of simply running them. SPSS then writes the command into a Syntax Editor. The syntax tends to be verbose, specifying many options that are the defaults - syntax you write yourself tends to be much shorter and simpler. After you have pasted a command, you still need to run it to get any output.

How to Save presentation file

PowerPoint for Office 365 PowerPoint 2019 PowerPoint 2016 PowerPoint 2013 More...

As with any software program, it is a good idea to name and save your presentation immediately, and save your changes frequently while you work.

Newer versions Office 2010 Office 2007

In PowerPoint 2013 and newer versions, you can save your desktop presentation to your local drive (such as your laptop), a network location, a CD, a DVD, or a flash drive. You can also save it as a different file format. If you want to save your presentation to the web location, see Save and share a presentation to OneDrive.

On the File tab, select Save.
Do of the following:
- To save to your local drive, such as your laptop, a flash drive, CD or DVD drive, select Computer.
- To save to a SharePoint Library, select SharePoint.
- To save your presentation to a web location, see Save and share a presentation to OneDrive.
Under Save As > Recent Folders, select Browse, pick a path and file folder, and then name the file.
Select Save.

Save your presentation file in a different file format

Note: To save files in PDF (.pdf) or XPS (.xps) file formats, see Save or convert to PDF or XPS.

On the File tab, select Save As.
Under Save As, do one of the following:
Under Recent Folders, select Browse, pick a path and file folder, and then name the file.
In the Save as type list, pick the file format that you want.
Select Save.

Save your presentation in an earlier version of PowerPoint

In PowerPoint 2013 and newer versions, you can save files to an earlier version of PowerPoint by selecting the version from the Save as type list in the Save As box. For example, you can save your PowerPoint presentation in the newest PowerPoint Presentation format (.pptx), or as a PowerPoint 97-2003 Presentation (.ppt).

Notes:

PowerPoint 2013 and newer versions use an XML-based .pptx file format introduced in the 2007 Office release. These files can be opened in PowerPoint 2010 and PowerPoint 2007 without special add-ins or loss of functionality. For more information, see Open XML Formats and file name extensions.
For more information about compatibility between files from different releases, see Check whether a presentation can open with PowerPoint 2003 or earlier.

Open Document format

Microsoft Office supports the ability to save a presentation file in the OpenDocument Presentation format (.odp).
When you use the Save As or Save a Copy command, the option to save in .odp format is listed at the end of the Save as type list of options.

How to Add slides

Add and delete slides to organize your presentation.

Select the slide you want your new slide to follow.
Select Home > New Slide.
Select a layout.
Select the text box and type.

Delete slides

For a single slide: Right-click and select Delete Slide.
For multiple slides: Hold Ctrl and select the slides. Then right-click and select Delete Slide.
For a sequence of slides: Hold Shift and select the sequence. Then right-click and select Delete Slide.

Change Powerpoint theme colors

Theme colors contain four text and background colors, six accent colors, and two hyperlink colors. Under Sample, you can see how the text font styles and colors look before you settle on your color combination.

On the Design tab, in the Variants group, select the down arrow that opens the gallery of color variants:
Select Colors, and then click Customize Colors.
The Create New Theme Colors dialog box opens.
In the Create New Theme Colors dialog box, under Theme colors, do one of the following:
Select the button next to the name of the theme color element (for example, Accent 1 or Hyperlink) that you want to change, and then choose a color under Theme Colors.
-or-
Select More Colors, and do one of the following:
- On the Standard tab, select a color.
- On the Custom tab, enter a color formula number for the exact color that you want.
  Repeat for all of the theme color elements that you want to change.
In the Name box, type an appropriate name for the new combination of theme colors, and then select Save.

Tip: If you want to return all theme color elements to their original theme colors, select Reset before you select Save.
After you've defined a custom color scheme, it's available on the Colors drop-down menu:

Microsoft Powerpint Basic [Choose a Theme}

When you open PowerPoint, you’ll see some built-in themes and templates. A theme is a slide design that contains matching colors, fonts, and special effects like shadows, reflections, and more.

Shows the Create New presentation from Theme dialog in PowerPoint

On the File tab of the Ribbon, select New, and then choose a theme.

PowerPoint shows you a preview of the theme, with four color variations to choose from on the right side.
Click Create, or pick a color variation and then click Create.

Insert a new slide

On the Home tab, click the bottom half of New Slide, and pick a slide layout.

Read more: Add, rearrange, and delete slides.

Save your presentation

On the File tab, choose Save.
Pick or browse to a folder.
In the File name box, type a name for your presentation, and then choose Save.

Note: If you frequently save files to a certain folder, you can ‘pin’ the path so that it is always available (as shown below).

Tip: Save your work as you go. Press Ctrl+S often.

Add text

Select a text placeholder, and begin typing.
Shows adding text to a text field in PowerPoint

Format your text

Select the text.
Under Drawing Tools, choose Format.
Do one of the following:
- To change the color of your text, choose Text Fill, and then choose a color.
- To change the outline color of your text, choose Text Outline, and then choose a color.
- To apply a shadow, reflection, glow, bevel, 3-D rotation, a transform, choose Text Effects, and then choose the effect you want.

File Tab View for Microsoft Word 2010

In this chapter, we will discuss the Backstage View in Word 2010. The Backstage view was introduced in Word 2010. This acts as the central place for managing your documents. The backstage view helps in creating new documents, saving and opening documents, printing and sharing documents, and so on.
Getting to the Backstage View is easy: Just click the File tab, located in the upper-left corner of the Word Ribbon. If you already do not have any opened document, then you will see a window listing down all the recently opened documents as follows −
Word Backstage View

If you already have an opened document, then it will display a window showing detail about the opened document as shown below. Backstage view shows three columns when you select most of the available options in the first column.
Word Backstage View 2

The first column of the backstage view will have following options −

No	Description& Option
1	Save If an existing document is opened, it will be saved as is, otherwise it will display a dialogue box asking for the document name.
2	Save As A dialogue box will be displayed asking for document name and document type, by default it will save in word 2010 format with extension .docx.
3	Open This option is used to open an existing word document.
4	Close This option is used to close an open document.
5	Info This option displays information about the opened document.
6	Recent This option lists down all the recently opened documents
7	New This option is used to open a new document.
8	Print This option is used to print an open document.
9	Save & Send This option will save an open document and will display options to send the document using email, etc.
10	Help This option is used to get the required help about Word 2010.
11	Options This option is used to set various option related to Word 2010.
12	Exit Use this option to close the document and exit.

Document Information

When you click the Info option available in the first column, it displays the following information in the second column of the backstage view −

Compatibility Mode − If the document is not a native Word 2007/2010 document, a Convert button appears here, enabling you to easily update its format. Otherwise, this category does not appear.
Permissions − You can use this option to protect your word document. You can set a password so that nobody can open your document, or you can lock the document so that nobody can edit your document.
Prepare for Sharing − This section highlights important information you should know about your document before you send it to others, such as a record of the edits you made as you developed the document.
Versions − If the document has been saved several times, you may be able to access the previous versions of it from this section.

Document Properties

When you click the Info option available in the first column, it displays various properties in the third column of the backstage view. These properties include the document size, the number of pages in the document, the total number of words in the document, the name of the author etc.
You can also edit various properties by clicking on the property value and if the property is editable, then it will display a text box where you can add your text like title, tags, comments, Author.

Exit Backstage View

It is simple to exit from the Backstage View. Either click on the File tab or press the Esc button on the keyboard to go back to the working mode of Word.