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

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.

Automated summary

This paper demonstrates how advanced health economic analysis techniques performed in Microsoft Excel can be transferred to R. It provides a step-by-step guide using a Markov model in R and compares the results with established analyses in Microsoft Excel, using a previously published case study of a hip replacement surgery cost-effectiveness model. The paper aims to facilitate the switch from Microsoft Excel to R for complex health economic analyses and provides open-access code and data for future adaptation.