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.
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.
This tutorial illustrates the practical application of MetaXL for synthesizing meta-analytical evidence, with a focus on common effect sizes and their presentation.
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.
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函数。准确填充此函数并遵循正确格式对于确保无错误分析至关重要。