Archive for May 10th, 2006

Make your codebook

This example is based on a market research project. In this project a questionnaire went out and we got a lot of data back from our respondents. To have a guideline when filling in your data, using a codebook is very handy. In fact, it is essential if someone else is filling in data for you. Below you can find an explanation on how to make this codebook.

1. Make a copy of your questionnaire document, and name it e.g. codebook.doc (a little obvious, I know).
2. Change the question numbers into variable names. The most logical thing to do is to give question 1 the variable name q1, question 2 the variable name q2, etc.

SPSSlog.com Codebook

3. Now start coding the answer categories. If your question has only one possible answer, than you can code the first answer as 1, the second as 2.

SPSSlog.com Codebook 2

4. If your question has multiple possible answers, than you should take a different approach. The most handy one is the following. For each possible answer, you make a new variable. For example, the first possible answer for question 11, you give the variable 11a. The second possible answer, give it variable 11b, etc.

SPSSlog.com Codebook multiple choice

After you have done this, you can start define your variables in SPSS.

Files used for this example:

SPSSlog.com example data sheet
SPSSlog.com SPSS file
SPSSLog.com example questionnaire

2 comments May 10th, 2006 andris


Calendar

May 2006
M T W T F S S
« Apr   Aug »
1234567
891011121314
15161718192021
22232425262728
293031  

Posts by Month

Posts by Category