摘要
目的:介绍Excel办公软件在调查问卷中多选题答案编码的拆分中的应用。方法:通过实例介绍Excel完成多选题答案编码拆分的具体步骤。结果:通过Excel内置公式或VBA可进行多选题答案编码的拆分。结论:通过Excel进行多选题编码的拆分操作简单,适合不熟悉SPSS,SAS等统计软件人员使用。
Objective： To introduce the application of Excel in code splitting of multiple-choice answers in questionnaire. Methods： The steps of code splitting in Excel were illustrated by an example. Results： Code splitting can be performed by Excel formulas or Excel VBA. Conclusion： Code splitting can be easy done by Excel, particularly suitable for those who are not familiar with the statistical software such as SPSS, SAS,
出处
《数理医药学杂志》
2013年第4期466-468,共3页
Journal of Mathematical Medicine
基金
广州市医药卫生科技项目(20131A011103)
关键词
EXCEL
问卷
多选题
Excel
questionnaire
multiple-choice questions
