Wednesday, April 14, 2010

SPSS Text Analysis

Getting your Data Ready for Text Analysis

Most of our open response data comes from SPSS documents, and text analysis claims to be able to import your items directly from an SPSS data document; however, it has been my experience that this never works. You will need to then go into your SPSS data, select the variables that you want to export, and then export them to an Excel file.

Here is what the Excel file should look like (click to enlarge):


It needs an ID column, and each column after that would be another one of your open response items (with the responses following below each title).

Importing your Data into Text Analysis

Note: You will want to save your Excel file (and all of your further files from here on out) in one folder that you will NEVER move. The reason for this is that if you ever move one of the files (even move the folder that contains all of the files to a different place) it will break all of the connections that have been set up between Text Analysis and your Excel data file. This will cause you to lose much if not all of what you have done (even after you try to have the program rebuild the connections).

This tutorial was not continued because we switched over to MAXQDA.

No comments:

Post a Comment