A Weekend With SPSS

Let me preface everything in this post with the statement that SPSS is a remarkable tool for data analysis and that I’m not an SPSS expert – I used to have passing familiarity with SAS (different beast) and some college-level statistics from nearly twenty years ago.

Over the weekend I spent a couple of hours working with SPSS 14 on a data set from some 700 phone surveys with customers. Setting aside the fact that the data set I was working on was big (not huge, but 700 people times something like 40 questions is big) and unfamiliar (I didn’t know what any of the questions really meant when I went into the data), I have to say that it is a complex product, but surprisingly navigable to a newbie.

My main purpose was to find correlations in the data set so I could reduce the number of distinct questions I needed to identify a characteristic. So, for example, if I found that age had a strong correlation with gray hair, I could use one of the two as a variable to help me identify a particular group of people. By contrast, I also wanted to find variables that would usefully identify groups of people – say, age and height, which aren’t highly correlated in most sample populations. (Understand that my data set was targeted at people who write code, so things like “height” weren’t on the question list.)

To start with, I have to be RASsed into corpnet for the Microsoft license to work. Annoying. Secondly, the product has a very slow startup (license verification, package loading, etc.). But once running, I could run my correlations by pulling down the Analyze menu and selecting Correlate. Basically everything I wanted to do was about that simple. I needed to refer either to the documentation or to the Web for information on the different methods used for things like correlations, but in the end the defaults always seemed to be most useful.

Basically, I have to say that for a complex topic (statistics) and a big product, it’s pretty navigable.

Comments (2)

  1. Squeaky says:

    I’ve always thought that SPSS was far more newbie-friendly than SAS, but maybe you can correct me if I’m wrong.  Even though SAS has a learning edition, I believe that it eventually times-out.  

    Why American businesses don’t use statistics more often than they do boggles my mind.  

    So John, Did you actually perform the 741 combinations of Pearson’s R to compare each question to the 39 others?

  2. johnmont says:

    Nope — I did about a dozen correlations on the most obvious variables I thought would be related in aggregate, found no amazing insights, and broke for lunch.

    I would have liked to have spent the time to write some code that would have run all the possible combinations and provided me with a prioritized list of results, but I ran out of time.