| Excel在复杂随机抽样中的应用 |
| |
| 引用本文： | 刘伟,;贾士杰.Excel在复杂随机抽样中的应用[J].数理医药学杂志,2014(3):347-349. |
| |
| 作者姓名： | 刘伟 ;贾士杰 |
| |
| 作者单位： | [1]广州市疾病预防控制中心,广州510440; [2]广州市第八人民医院,广州510440; |
| |
| 基金项目： | 广州市医药卫生科技项目（20131A011103） |
| |
| 摘 要： | 目的:介绍Excel办公软件在复杂随机抽样中的应用。方法:通过实例介绍Excel完成复杂随机抽样的的具体步骤。结果:通过Excel内置公式结合VBA编程可进行复杂随机抽样。结论:通过Excel能够简单快速的完成现场流行病学调查中的复杂随机抽样,特别适合不熟悉SPSS,SAS等统计软件人员使用。
|
| 关 键 词： | Excel 问卷 多选题 |
Application of Excel in complex random sampling |
| |
| Institution: | Liu Wei,et al (Guangzhou Center for Disease Control and Prevention, Guangzhou 510440) |
| |
| Abstract: | 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. |
| |
| Keywords: | Excel random sampling epidemiology |
| 本文献已被 CNKI 维普 等数据库收录！ |
