Fall in love with SPSS again: Mapping in SPSS 20

Leave a comment

SPSS manages to keep their throne as the most widely-used statistical analysis software in social science. They have outdone themselves, yet again, with SPSS 20.

The Maps feature is at the forefront of the collection of new updates in this recent release. Now, you can incorporate geography into your quantitative research, in order to visualize geographical observations or trends.

This feature is contained in Graph > Graphboard Template Chooser. There are three types of map templates:

  1. Choropleth Maps, where you can use color gradation to reflect the value of statistic on a variable (mean, median, and sum).
  2. Mini Charts, displaying a chart for certain regions; each labeled with the respective location.
  3. Overlay Maps, combining two map files into one visualization; one as reference, another for data display.

You can work with the following data:

  1. Latitude and Longitude, in order to generate a reference map with geographical coordinates.
  2. Existing map files: ESRI shapefiles easily converted with the Map Conversion Utility
  3. Pre-installed maps in SMZ format, including the U.S. map with states and cities indicated

For additional map files: “Many of the templates in this product are based on publicly available data obtained from GeoCommons (http://www.geocommons.com) and the U.S. Census Bureau (http://www.census.gov). Another source for U.S. federal, state, and local geospatial data is the U.S. Geological Survey (http://www.geodata.gov).”

There are various ways to customize your map to display the data as you desire, including color schemes (stylesheet) as well as Pie on a Map.

Pie on a Map

Reference Map with Latitude and Longitude

SPSS 20 is now available on all the computers in Hurst 202 and 203.


IBM. SPSS. Program documentation. Converting and Distributing Map Shapefiles. Vers. 20. IBM, 2011. Web. 14 Feb. 2012. <http://publib.boulder.ibm.com/infocenter/spssstat/v20r0m0/index.jsp?topic=%2Fcom.ibm.spss.statistics.help%2Fmapconversion_intro.htm&gt;.


PSPP: SPSS’s Alter Ego

1 Comment

You’re considering getting your own copy of SPSS on your personal computer and you begin to browse for the program online (although if you have an AU-owned computer, you can just get it installed from us).  You want more than the free trial version that the makers of SPSS offers but you don’t want to pay the price. What to do? There is an option (a FREE option, if we may add) out there that may help: PSPP.

What is PSPP?

PSPP is a free software application for statistical analysis. It is intended to be a free replacement of the proprietary program SPSS. When you open PSPP, you’ll find that the interface looks very similar to SPSS with a few exceptions. All functionality that PSPP currently supports is in the core package.

PSPP has a data view tab (spreadsheet), a variable view tab (to create variables and define their characteristics) and has an easy to use point-and-click interface.

From the PSPP website: PSPP can perform descriptive statistics, T-tests, linear regression and non-parametric tests. Its backend is designed to perform its analyses as fast as possible, regardless of the size of the input data. You can use PSPP with its graphical interface or the more traditional syntax commands.

Again, PSPP is very similar to SPSS.  Even the output window is comparable to SPSS.

A brief list of some of the features of PSPP follows:

  • Supports over 1 billion cases.
  • Supports over 1 billion variables.
  • Syntax and data files are compatible with SPSS.
  • Choice of terminal or graphical user interface.
  • Choice of text, postscript or html output formats.
  • Inter-operates with Gnumeric, OpenOffice.org  and other free software.
  • Easy data import from spreadsheets, text files and database sources.
  • Fast statistical procedures, even on very large data sets.
  • No license fees.
  • No expiration period.
  • No unethical “end user license agreements”.
  • Fully indexed user manual.
  • Free Software; licensed under GPLv3 or later.
  • Cross platform; Runs on many different computers and many different operating systems.

Visit PSPP’s website to learn more about the software and information on how install it.  Don’t forget to look closely at the different installation instructions for PCs and Macs.

SPSS Tutorial Videos on YouTube

Leave a comment

Need some last-last-minute help with SPSS?

California State University, Los Angeles, has a great YouTube channel that has several videos on how to use SPSS.  There are videos on how to download data files, define variables, entering data, and how to do various analyses, like crosstabs, t-tests, regressions, and more.

Below is an example of one of their videos. This one is a basic intro to SPSS:


This channel is also really handy if you need a refresher on how to use SPSS.  Most of the videos are between 4 and 5 minutes long, so they’re also really good if you need to remember how to do that one thing that slipped your mind. We have a more recent version of SPSS in the lab, but the steps to do these analyses are the same! Ask a consultant for help if you need additional assistance.

Quick Way to Find Variables on SPSS


When you’re using SPSS, have you had those moments when you’re endlessly looking for a certain variable, but in a list of 100+ you never seem to do it quickly?  Do not waste time scrolling through your giant database; instead, take this tip from us:

First, remember that SPSS stores your variables with a name (= a code for the variable, which should only be a word) and a label (= an explanation of what your variable is in a whole sentence). Second, whenever you want to do an operation in SPSS (i.e. get descriptive statistics for a variable) the window for this will show a list of the variables that by default presents the labels.  If you point the cursor over this list (anywhere on this list of variables is fine) you can right click the list and choose that you want to see the “names” of these variables.  If you right click again you can indicate that you want to see an “alphabetical sort” of the variables.

 And done!  We suggest looking at variable names because is just a word and is likely that you would know this, plus the alphabetical sorting tends to make more sense with the variable name rather than the code.

Please leave a comment if you think this was useful, and ask a consultant if you have a question using SPSS!

On Perfecting Your Paper: How to make a table fit on a page

Leave a comment

You are almost done with your research project! Woo hoo! Just one problem. When you pasted your tables from SPSS to Word, they look like this:

Off the page - Not what you want

You’re miffed about this, but don’t worry; this sometimes happens with really long tables that are copied from the SPSS output.  This can be fixed in two easy steps:

1. Right-click on the table and choose “AutoFit”.

2. Then choose “AutoFit to Window”.

Ta da! A table that fits on the page! You can also enhance the look of the table by playing with Microsoft Word’s table formatting options. Click on the box that has a little cross in it at the top left-hand corner (as seen above) and the table formatting options will appear at the top of the screen. Ask a consultant for help if you get  lost.


Leave a comment


Are you still trying to decide which statistical package to use for your research project? Take a quick tip from one of our consultants to help make your decision:

These are some of the pros and cons of using SPSS or Stata for your research analyses.


SPSS is good for managing basic datasets and if you are not going to do cutting-edge statistical analysis.  Its biggest advantage is that it is user friendly because its layout is so much like the familiar Excel spreadsheet.

Although both SPSS and Stata have a menu-driven option, the point and click menus in SPSS are the easiest to learn. You could say that SPSS has moved away from an academic research focus and seems to invest more of its development in marketing-oriented graphics. Many NGO’s, banks and related type entities would most likely not use SPSS for their work and would choose Stata over it.

SPSS’s graphics are very professional and they look appealing. The great thing about graphics generated on SPSS is that you can edit them as you please (colors, labels, size, etc).

SPSS screenshot


This program is widely used in NGO’s, banks and many other organizations that require data analysis. It is best for complex statistical analyses. Unlike SPSS’s “drop-down menu” feature, Stata tends to be more “command-based”.

The first window you encounter will not be the friendly table layout that you may be used to seeing in Excel. The layout may catch you by surprise, but once you get used to what each window tells you, it becomes fairly easy to use. It has a command window in which you can type exactly what you want to do (i.e. for a regression between two variables named “infmort” and “doctors” you would type: “reg infmort doctors”, hit Enter and your regression analysis pops up).  It is very intuitive and produces very professional output tables.

Stata screenshot

If you can’t decide which program to use for your analysis, consider even using both.  As always, ask a consultant for help if you need further assistance!

A Beautiful Union: How to merge data on SPSS

1 Comment

You’ve just spent hours finding the perfect data for your project. The problem now is that you have two (or more) different data sets and you need to smoosh them all into one. Here is how you can do that:

YouTube video: California State University, ITS Training Program

1. First, the two data sets you want to merge need to have a common, unique identifier (key variable) for each case in your data set. Both data files should provide different data for the same set of cases. Also, make sure the cases are spelled exactly the same and are in the same order in both data sets (You could try sorting them in ascending order before trying to merge).

2. Open the first file that you wish to merge. Under the “Merge Files” item in the Data menu, select “Add Variables”

3. Select the file you wish to merge

4. If the cases have the same name one will show up in the “Excluded Variables” list. This will be the common variable that you will use to merge the data files together. If your key variables have different names you should rename one so they both have the same name. Select the key variable from the “Excluded Variables” list and check the “Match cases on key variables in sorted files” checkbox. Then send the variable to the key variables box (using the arrow pointing to the right).

5. Click OK. SPSS will give you a warning regarding sorted key variables. If everything is in order (make sure both files have key variables that are spelled the same and are sorted in order before trying to do a file merge) click OK again. All variables from both files will be merged in a new datafile, and cases are matched by the key variable.

As always, ask a consultant for help if you get lost!

%d bloggers like this: