• 文献检索
  • 文档翻译
  • 深度研究
  • 学术资讯
  • Suppr Zotero 插件Zotero 插件
  • 邀请有礼
  • 套餐&价格
  • 历史记录
应用&插件
Suppr Zotero 插件Zotero 插件浏览器插件Mac 客户端Windows 客户端微信小程序
定价
高级版会员购买积分包购买API积分包
服务
文献检索文档翻译深度研究API 文档MCP 服务
关于我们
关于 Suppr公司介绍联系我们用户协议隐私条款
关注我们

Suppr 超能文献

核心技术专利：CN118964589B侵权必究
粤ICP备2023148730 号-1Suppr @ 2026

文献检索

告别复杂PubMed语法，用中文像聊天一样搜索，搜遍4000万医学文献。AI智能推荐，让科研检索更轻松。

立即免费搜索

文件翻译

保留排版，准确专业，支持PDF/Word/PPT等文件格式，支持 12+语言互译。

免费翻译文档

深度研究

AI帮你快速写综述，25分钟生成高质量综述，智能提取关键信息，辅助科研写作。

立即免费体验

使用MetaXL插件在Microsoft Excel中掌握Meta分析：Meta分析全面教程与指南

Mastering meta-analysis in Microsoft Excel with MetaXL add-in: A comprehensive tutorial and guide to meta-analysis.

作者信息

Elmakaty Ibrahim

机构信息

Department of Medical Education, Hamad Medical Corporation, Doha, Qatar.

出版信息

J Eval Clin Pract. 2025 Mar;31(2):e14138. doi: 10.1111/jep.14138. Epub 2024 Oct 2.

DOI:10.1111/jep.14138
PMID:39359009
原文链接:https://pmc.ncbi.nlm.nih.gov/articles/PMC11938408/
Abstract

RATIONALE

Meta-analysis, a powerful technique for combining effect estimates from multiple studies, enhances statistical power and precision. However, its adoption can be hindered by challenges in statistical interpretation and the complexity of specialized software. MetaXL, a freely available Microsoft Excel add-in, aims to mitigate these barriers by providing comprehensive support and facilitating seamless integration of meta-analytical results into research publications.

AIMS AND OBJECTIVES

This tutorial illustrates the practical application of MetaXL for synthesizing meta-analytical evidence, with a focus on common effect sizes and their presentation.

METHOD

This paper reintroduce MetaXL's functions and provide concise explanations of common effect sizes employed in meta-analysis. The tutorial delves into fundamental concepts such as the selection of appropriate effect sizes for pooling and the choice of meta-analytical models. Eight illustrative examples are presented, incorporating diverse effect sizes and data formats, including scenarios involving incidence rate ratios, weighted and standardized mean differences, hazard ratios, and prevalence. Additionally, key concepts in network meta-analysis are discussed, along with their implementation in MetaXL. MetaXL provides convenient access to data formatting templates tailored to various data types and effect sizes encountered in included studies.

RESULTS AND CONCLUSION

This tutorial offers researchers, particularly those with limited resources, detailed explanations and insights into commonly used methodologies for pooling effect sizes. Furthermore, it introduces the new Excel functions that comes with the MetaXL add-in. Accurate population of this function and adherence to the correct format are essential to ensure error-free analyzes.

摘要

原理

荟萃分析是一种整合多项研究效应估计值的强大技术，可提高统计功效和精度。然而，其应用可能会受到统计解释方面的挑战以及专业软件复杂性的阻碍。MetaXL是一款免费的Microsoft Excel插件，旨在通过提供全面支持并促进将荟萃分析结果无缝整合到研究出版物中，来减轻这些障碍。

目的

本教程阐述了MetaXL在综合荟萃分析证据方面的实际应用，重点关注常见效应量及其呈现方式。

方法

本文重新介绍了MetaXL的功能，并对荟萃分析中常用的效应量进行了简要解释。该教程深入探讨了一些基本概念，如用于合并的适当效应量的选择以及荟萃分析模型的选择。给出了八个示例，涵盖了不同的效应量和数据格式，包括发病率比、加权和标准化均数差、风险比及患病率等情况。此外，还讨论了网络荟萃分析中的关键概念及其在MetaXL中的实现。MetaXL提供了针对纳入研究中遇到的各种数据类型和效应量量身定制的数据格式化模板的便捷访问。

结果与结论

本教程为研究人员，尤其是资源有限的研究人员，提供了关于合并效应量常用方法的详细解释和见解。此外，它还介绍了MetaXL插件附带的新Excel函数。准确填充此函数并遵循正确格式对于确保无错误分析至关重要。

https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/6ef12feb3762/JEP-31-0-g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/82aabe8faa2f/JEP-31-0-g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/783afc96ccf2/JEP-31-0-g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/e2c8a028550f/JEP-31-0-g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/5010eadc872d/JEP-31-0-g011.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/016fdea5d1be/JEP-31-0-g009.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/d936bcac1c45/JEP-31-0-g014.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/bd3424f74d52/JEP-31-0-g015.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/91d052851769/JEP-31-0-g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/cbc7cf672eb0/JEP-31-0-g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/064e9635b510/JEP-31-0-g010.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/6c916fa52a6c/JEP-31-0-g012.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/ce3275aac3af/JEP-31-0-g016.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/1b61926fbff0/JEP-31-0-g013.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/04c7f40bf6d2/JEP-31-0-g008.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/7ae1c98b0da5/JEP-31-0-g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/6ef12feb3762/JEP-31-0-g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/82aabe8faa2f/JEP-31-0-g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/783afc96ccf2/JEP-31-0-g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/e2c8a028550f/JEP-31-0-g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/5010eadc872d/JEP-31-0-g011.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/016fdea5d1be/JEP-31-0-g009.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/d936bcac1c45/JEP-31-0-g014.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/bd3424f74d52/JEP-31-0-g015.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/91d052851769/JEP-31-0-g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/cbc7cf672eb0/JEP-31-0-g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/064e9635b510/JEP-31-0-g010.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/6c916fa52a6c/JEP-31-0-g012.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/ce3275aac3af/JEP-31-0-g016.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/1b61926fbff0/JEP-31-0-g013.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/04c7f40bf6d2/JEP-31-0-g008.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/7ae1c98b0da5/JEP-31-0-g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/0cec/11938408/6ef12feb3762/JEP-31-0-g001.jpg

相似文献

1
Mastering meta-analysis in Microsoft Excel with MetaXL add-in: A comprehensive tutorial and guide to meta-analysis.使用MetaXL插件在Microsoft Excel中掌握Meta分析：Meta分析全面教程与指南
J Eval Clin Pract. 2025 Mar;31(2):e14138. doi: 10.1111/jep.14138. Epub 2024 Oct 2.
2
Folic acid supplementation and malaria susceptibility and severity among people taking antifolate antimalarial drugs in endemic areas.在流行地区，服用抗叶酸抗疟药物的人群中，叶酸补充剂与疟疾易感性和严重程度的关系。
Cochrane Database Syst Rev. 2022 Feb 1;2(2022):CD014217. doi: 10.1002/14651858.CD014217.
3
A Microsoft-Excel-based tool for running and critically appraising network meta-analyses--an overview and application of NetMetaXL.一种基于Microsoft Excel的用于开展和严格评价网状Meta分析的工具——NetMetaXL概述及应用
Syst Rev. 2014 Sep 29;3:110. doi: 10.1186/2046-4053-3-110.
4
Robust variance estimation with dependent effect sizes: practical considerations including a software tutorial in Stata and spss.具有相依效应量的稳健方差估计：实用注意事项，包括 Stata 和 SPSS 中的软件教程。
Res Synth Methods. 2014 Mar;5(1):13-30. doi: 10.1002/jrsm.1091. Epub 2013 Aug 14.
5
Software to Conduct a Meta-Analysis and Network Meta-Analysis.用于进行荟萃分析和网络荟萃分析的软件。
Methods Mol Biol. 2022;2345:223-244. doi: 10.1007/978-1-0716-1566-9_14.
6
Meta-analysis of prevalence.患病率的荟萃分析。
J Epidemiol Community Health. 2013 Nov 1;67(11):974-8. doi: 10.1136/jech-2013-203104. Epub 2013 Aug 20.
7
Impact of summer programmes on the outcomes of disadvantaged or 'at risk' young people: A systematic review.暑期项目对处境不利或“有风险”的年轻人的影响：一项系统综述。
Campbell Syst Rev. 2024 Jun 13;20(2):e1406. doi: 10.1002/cl2.1406. eCollection 2024 Jun.
8
Conducting power analysis for meta-analysis with dependent effect sizes: Common guidelines and an introduction to the POMADE R package.进行具有相依效应量的荟萃分析的功效分析：常用指南和 POMADE R 包简介。
Res Synth Methods. 2024 Nov;15(6):1214-1230. doi: 10.1002/jrsm.1752. Epub 2024 Sep 18.
9
Rex: R-linked EXcel add-in for statistical analysis of medical and bioinformatics data.Rex：用于医学和生物信息学数据统计分析的R链接Excel插件。
Genes Genomics. 2023 Mar;45(3):295-305. doi: 10.1007/s13258-022-01361-7. Epub 2023 Jan 25.
10
Assessing the comparative effects of interventions in COPD: a tutorial on network meta-analysis for clinicians.评估慢性阻塞性肺疾病干预措施的比较效果：面向临床医生的网状Meta分析教程
Respir Res. 2024 Dec 21;25(1):438. doi: 10.1186/s12931-024-03056-x.

引用本文的文献

1
Prioritizing circulation over airway to improve survival in trauma patients with exsanguinating injuries: a world society of emergency surgery-panamerican trauma consensus statement.在有大出血性损伤的创伤患者中优先考虑循环而非气道以提高生存率：世界急诊外科学会 - 泛美创伤共识声明
World J Emerg Surg. 2025 Jun 2;20(1):47. doi: 10.1186/s13017-025-00618-2.
2
Efficacy of Dose Escalation of Ustekinumab in Inflammatory Bowel Disease: A Systematic Review and Meta-Analysis.优特克单抗剂量递增在炎症性肠病中的疗效：一项系统评价和荟萃分析
Med Princ Pract. 2025;34(3):226-237. doi: 10.1159/000543831. Epub 2025 Feb 3.

本文引用的文献

1
Types of Analysis: Planned (prespecified) vs Post Hoc, Primary vs Secondary, Hypothesis-driven vs Exploratory, Subgroup and Sensitivity, and Others.分析类型：计划（预先指定）分析与事后分析、主要分析与次要分析、假设驱动分析与探索性分析、亚组分析和敏感性分析以及其他分析。
Indian J Psychol Med. 2023 Nov;45(6):640-641. doi: 10.1177/02537176231216842. Epub 2023 Nov 22.
2
Angry scientists, angry analysts and angry novelists.愤怒的科学家、愤怒的分析师和愤怒的小说家。
Diabetologia. 2023 Aug;66(8):1580-1583. doi: 10.1007/s00125-023-05917-4. Epub 2023 May 22.
3
Clinicopathological and prognostic value of chemokine receptor CCR7 expression in head and neck squamous cell carcinoma: a systematic review and meta-analysis.
趋化因子受体CCR7在头颈部鳞状细胞癌中的临床病理及预后价值：一项系统综述和荟萃分析
Expert Rev Anticancer Ther. 2023 Apr;23(4):443-453. doi: 10.1080/14737140.2023.2177156. Epub 2023 Feb 14.
4
Efficacy and safety of COVID-19 vaccines: A network meta-analysis.COVID-19 疫苗的疗效和安全性：一项网络荟萃分析。
J Evid Based Med. 2022 Sep;15(3):245-262. doi: 10.1111/jebm.12492. Epub 2022 Aug 23.
5
The Freeman-Tukey double arcsine transformation for the meta-analysis of proportions: Recent criticisms were seriously misleading.用于比例荟萃分析的弗里曼-图基双反正弦变换：近期的批评极具误导性。
J Evid Based Med. 2021 Dec;14(4):259-261. doi: 10.1111/jebm.12445. Epub 2021 Oct 11.
6
Network Meta-Analysis.网络荟萃分析。
Methods Mol Biol. 2022;2345:187-201. doi: 10.1007/978-1-0716-1566-9_12.
7
Conducting proportional meta-analysis in different types of systematic reviews: a guide for synthesisers of evidence.在不同类型的系统评价中进行比例荟萃分析：证据综合者的指南。
BMC Med Res Methodol. 2021 Sep 20;21(1):189. doi: 10.1186/s12874-021-01381-z.
8
The incidence rate of herpes zoster in inflammatory bowel disease: A meta-analysis of cohort studies.炎症性肠病患者中带状疱疹的发病率：一项队列研究的荟萃分析。
Medicine (Baltimore). 2021 Aug 20;100(33):e26863. doi: 10.1097/MD.0000000000026863.
9
Bias Assessment in Outcomes Research: The Role of Relative Versus Absolute Approaches.结局研究中的偏倚评估：相对与绝对方法的作用。
Value Health. 2021 Aug;24(8):1145-1149. doi: 10.1016/j.jval.2021.02.011. Epub 2021 May 19.
10
The MethodologicAl STandards for Epidemiological Research (MASTER) scale demonstrated a unified framework for bias assessment.方法学标准在流行病学研究（MASTER）量表中表现出一个统一的偏倚评估框架。
J Clin Epidemiol. 2021 Jun;134:52-64. doi: 10.1016/j.jclinepi.2021.01.012. Epub 2021 Jan 21.