Not too long ago, I wrote an article here about advanced procedures for examining interactions in multiple regression. As I described some of the challenges researchers commonly face in trying to examine differences between people in a data set, I argued that when it comes to data analysis, splitting a continuous variable into a dichotomy (i.e. two categories) is kind of a dumb idea (MacCallum et al, 2002). Continue reading
Tag Archives: SPSS
Data management with SPSS + MS Excel
Like many others, I have historically used SPSS as my go-to data management program. Many of those with whom I work do the same, and with good reason. It’s flexible and fairly easy to use for basic data management tasks (and let’s be honest, most people are trained in SPSS during their initiation into data analysis in psychology). One life changing moment for many users of SPSS is the day that one realizes the utility of the syntax window vis a vis the point and click interface. This becomes more apparent during the data management phase than perhaps at any other point. This article assumes that you’re already past this point of no return.
Basics: How SPSS syntax will change your life.
During my undergraduate years I spent large segments of my working week learning SPSS. Much of it was trial and error (ok, mostly error), but in my trials I recall one consistent experience. An experience that is familiar to many other students, I’m sure.
SPSS Correlation Tabulator (v 1.4)
The Correlation Tabulator is a tool I designed for use with SPSS. It will require you to run a set of Pearson correlations in SPSS, paste the correlation table output into the tabulator (if you follow the instructions, of course). It will then take those results and compile them into an APA-style correlation table (coefficients reported to two decimal places, with asterisks indicating significance levels), which you can copy and paste into Word or a similar program.
SPSS Regression Tabulator (v 2.2)
The Regression Tabulator is an Excel-based tool developed for use with SPSS regression analysis output. It is designed to accommodate multiple regression with a maximum of 20 predictor variables (which you will need to define). If you paste your “Coefficients” table into the worksheet (with or without confidence intervals), it will convert your SPSS output into three APA-style tables for you to choose from. The first features complete information unstandardized coefficients (B, SE, t, p). The second and third are truncated tables (unstandardized and standardized, respectively) that include reports of the model coefficients and standard errors, with asterisks indicating significance levels.