EXCEL筛选功能在SPSS问卷数据查错中的应用

The Application of the Data Filter Function in Excel for Error Checking in SPSS Survey Database

根据调查问卷中常见的若干问题类型分别给出了其在SPSS中的编码方法,并且针对不同的编码方法所得到的问卷数据,给出了利用Excel筛选功能对相应的数据进行查错的方法。

This paper gives the different coding methods in SPSS in accordance with various common types of questions in the survey questionnaires, and the corresponding error checking methods with the Excel filter function according to the questionnaire database resuited from various types of coding ways.