Here are a few tools designed specifically for use with SPSS.

All tools are available for free download.

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 “Model Coefficients” table into the worksheet, 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 stars indicating significance levels.

To use the table output, simply copy and paste into Word or a similar word processing program. The bottom row of the table (i.e., the row containing probability indicators) can also be pasted into a document.

As I discover glitches or figure out ways to improve or expand the tool’s capability, I’ll make revisions available.


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 crunch them into an APA-style correlation table, which you can then copy and paste into Word or a similar program.

You will need to make some small formatting adjustments afterwards (e.g., alignments and sizing between columns are things I’m still working on here – I don’t know of a way to properly fix this yet in Excel), but the basics should be in place if it works correctly. If I manage to figure out a solution, this tool will be updated.

Notes: The Correlation Tabulator can only accommodate a 20×20 correlation matrix.

DISCLAIMER: I cannot guarantee that any of the tools provided here will be 100% effective (but I’ve certainly tried). Use them at your discretion. I’m neither a programming whiz nor a stat expert. I merely develop these tools to the extent that my expertise and time allows (and to the extent that my work has demanded them). I hope you find them useful for your research & training.

Question or Comment?

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s