CAJ | 학술논문

目的：介绍 Excel办公软件在调查问卷中多选题答案编码的拆分中的应用。方法：通过实例介绍 Excel完成多选题答案编码拆分的具体步骤。结果：通过Excel内置公式或 VBA 可进行多选题答案编码的拆分。结论：通过 Excel进行多选题编码的拆分操作简单，适合不熟悉SPSS ，SAS等统计软件人员使用。
목적：개소 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 , etc .