Suppr超能文献

使用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.

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/82aabe8faa2f/JEP-31-0-g007.jpg

文献检索

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

立即免费搜索

文件翻译

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

免费翻译文档

深度研究

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

立即免费体验