应用EXCEL宏程序实现Meta分析中有序暴露与多结局资料研究效应量合并  

Facilitating Meta-analyses in Combing Effect Size from a Set of Estimates Presented by Ordinal Exposure Level or Disease Category

作　　者：周权[1] 郭鹏[2] 张超[3] 徐畅[3,4] 

机构地区：[1]常德市第一人民医院科教科,湖南常德415003 [2]湖北医药学院附属人民医院肝胆外科,湖北十堰442000 [3]十堰市太和医院(湖北医约学院附属)循证医学中心,湖北十堰442000 [4]武汉大学中南医院泌尿外科,武汉430071

出　　处：《中国循证医学杂志》2016年第8期978-983,共6页Chinese Journal of Evidence-based Medicine

基　　金：湖北省教育厅重点项目(编号:D20142102)

摘　　要：在Meta分析时,遇到有序暴露与多结局资料往往是一件令人烦恼的事,常规的"高VS低"方法,舍弃了中间组别的信息,降低了检验效能,本文介绍一种利用EXCEL宏程序实现Meta分析中有序暴露与多结局研究效应量合并的方法。全文先介绍合并思路和原理,再结合实例数据,利用EXCEL宏程序实现两类不同情况数据合并的过程。结果显示:两类不同情况数据合并结果与原始数据再次分析结果相似。因此,在无法获取原始研究数据的情况下,EXCEL宏程序能很好地解决有序暴露与多结局资料效应量合并的问题。when we conducted a meta-analysis, it is often an annoying thing to deal with the data of discrete exposure and multiple outcomes. Conventional ＂high VS low＂ approach abandoned the information of middle category, and led to the loss of statistical power. In this paper, we introduced a method and software to combine the groups of discrete exposure and multiple outcomes in the meta-analysis of epidemiological studies. Firstly, we introduced the transforming and combination theory and method, and then, we conducted the combination using EXCEL macro software. The result was consistent with the results of the original data in the combination of discrete exposure and multiple outcome data. Therefore, in the case of the original research data cannot be acquired, EXCEL macro software can be a good solution.

关 键 词：有序资料 转换 EXCEL宏 META分析 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] R-03[自动化与计算机技术—计算机科学与技术]