基于R及ExcelVBA混合编程实现自动化复杂抽样数据分析  

Implementation of Automatic Complex Sampling Data Analysis Based on R and Excel VBA Hybrid Programming

作　　者：林丰 林彩红 叶少英 钟荧 LIN Feng;LIN Caihong;YE Shaoying;ZHONG Ying(Guangdong Center for Health Publicity and Education,Guangzhou 510230,Guangdong Province,China)

机构地区：[1]广东省卫生健康宣传教育中心,广州510230

出　　处：《预防医学情报杂志》2020年第4期376-381,共6页Journal of Preventive Medicine Information

基　　金：广东省医学科研基金项目(项目编号:B2017013)。

摘　　要：目的开发健康素养数据分析程序,实现自动化健康素养复杂抽样数据统计分析。方法利用Excel函数和VBA程序,并通过BERT嵌入R语言,实现自动化复杂抽样数据统计分析,最后通过Excel输出结果。结果分析程序可实现变量转换、计算,权重计算及赋值,自动生成统计结果,结果正确。结论分析程序操作简便,可快速、准确分析结果。Objective To develop a analysis program for health literacy survey data in order to analyze complex sampling data of health literacy automatically.Methods Using the functions and VBA programs in Excel,and connecting with R program by BERT(Basic Excel R Toolkit)analyzes the complex samples automatically,and output the results by Excel finally.Results Using the program we developed,we can convert,calculate,weight and assign the variables,finally generate the statistical results automatically,and the results were proved to be accurate.Conclusion The program developed in this study operates simply,and the results can be analyzed quickly and accurately.

关 键 词：R EXCEL VBA 复杂抽样 分析 

分 类 号：R195[医药卫生—卫生统计学]