摘要
目的:介绍Excel办公软件在复杂随机抽样中的应用。方法:通过实例介绍Excel完成复杂随机抽样的的具体步骤。结果:通过Excel内置公式结合VBA编程可进行复杂随机抽样。结论:通过Excel能够简单快速的完成现场流行病学调查中的复杂随机抽样,特别适合不熟悉SPSS,SAS等统计软件人员使用。
Objective: To introduce the application of Excel in complex random sampling. Methods. The steps of complex random sampling in Excel were illustrated by an example. Results: Complex random sampling can be performed by Excel formulas combining with Excel VBA. Conclusion: Complex random sampling in field epidemiological investigation can be easily and quickly done by Excel, particularly suitable for those who are not familiar with the statistical software such as SPSS, SAS, etc.
出处
《数理医药学杂志》
2014年第3期347-349,共3页
Journal of Mathematical Medicine
基金
广州市医药卫生科技项目(20131A011103)
关键词
EXCEL
问卷
多选题
Excel
random sampling
epidemiology