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. 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. 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. Codebook multiple choice

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

Files used for this example: example data sheet SPSS file example questionnaire

2 comments May 10th, 2006 andris


May 2006
« Apr   Aug »

Posts by Month

Posts by Category