UCL Discovery Stage
UCL home » Library Services » Electronic resources » UCL Discovery Stage

Extensions of Health Economic Evaluations in R for Microsoft Excel Users: A Tutorial for Incorporating Heterogeneity and Conducting Value of Information Analyses

Naylor, Nichola R; Williams, Jack; Green, Nathan; Lamrock, Felicity; Briggs, Andrew; (2023) Extensions of Health Economic Evaluations in R for Microsoft Excel Users: A Tutorial for Incorporating Heterogeneity and Conducting Value of Information Analyses. PharmacoEconomics , 41 pp. 21-32. 10.1007/s40273-022-01203-0. Green open access

[thumbnail of s40273-022-01203-0.pdf]
Preview
Text
s40273-022-01203-0.pdf - Published Version

Download (1MB) | Preview

Abstract

Advanced health economic analysis techniques currently performed in Microsoft Excel, such as incorporating heterogeneity, time-dependent transitions and a value of information analysis, can be easily transferred to R. Often the outputs of survival analyses (such as Weibull regression models) will estimate the impacts of correlated patient characteristics on patient outcomes, and are utilised directly as inputs for health economic decision models. This tutorial provides a step-by-step guide of how to conduct such analyses with a Markov model developed in R, and offers a comparison with established analyses performed in Microsoft Excel. This is done through the conversion of a previously published Microsoft Excel case study of a hip replacement surgery cost-effectiveness model. We hope that this paper can act as a facilitator in switching decision models from Microsoft Excel to R for complex health economic analyses, providing open-access code and data, suitable for future adaptation.

Type: Article
Title: Extensions of Health Economic Evaluations in R for Microsoft Excel Users: A Tutorial for Incorporating Heterogeneity and Conducting Value of Information Analyses
Location: New Zealand
Open access status: An open access version is available from UCL Discovery
DOI: 10.1007/s40273-022-01203-0
Publisher version: https://doi.org/10.1007/s40273-022-01203-0
Language: English
Additional information: This article is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, which permits any non-commercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by-nc/4.0/.
Keywords: Social Sciences, Science & Technology, Life Sciences & Biomedicine, Economics, Health Care Sciences & Services, Health Policy & Services, Pharmacology & Pharmacy, Business & Economics, EXPECTED VALUE, SAMPLE
UCL classification: UCL
UCL > Provost and Vice Provost Offices > UCL BEAMS
UCL > Provost and Vice Provost Offices > UCL BEAMS > Faculty of Maths and Physical Sciences
UCL > Provost and Vice Provost Offices > UCL BEAMS > Faculty of Maths and Physical Sciences > Dept of Statistical Science
URI: https://discovery-pp.ucl.ac.uk/id/eprint/10169731
Downloads since deposit
378Downloads
Download activity - last month
Download activity - last 12 months
Downloads by country - last 12 months

Archive Staff Only

View Item View Item