I frequently play around with multivariate techniques like K-means cluster analysis in SPSS. There were some big holes in the SPSS procedure that performs cluster analysis so wrote anSPSS Macro to automate what I wanted to be done. Below is a quick demo of the macro in use. It can really save a bunch of time! A few things mine does differently is:
assigns labels to the segments (these will be changed later but butter than just a 1,2,3)
Computes frequencies on the size of the segments (Why SPSS doesn’t do this automatically is beyond me)
I frequently need to randomize my lists and save them into separate text files. This SPSS macro makes it a breeze!
If you haven’t already played with macros you’ll want to get yourself familiar with them by reviewing this post on Intro to Macros. The macro will need a few parameters from you like: the path to save the files, Stem (beginning) name of the files to create, # of groups to create and whether or not to keep the variable used to create the groups.
A lot of online vendor tools provide a data value on a multi-select question however they leave the value missing if the respondent didn’t select it. Most of the analysis I want to do needs to have a zero (or some other value) present in order to calculate the statistics correctly.