Related Experiment Video
Updated: Aug 19, 2025

Author Spotlight: Evaluating the Adjuvant Efficacy and Safety of Angong Niuhuang Pill in Viral Encephalitis Treatment
Published on: April 19, 2024
Extensions of Health Economic Evaluations in R for Microsoft Excel Users: A Tutorial for Incorporating Heterogeneity
Nichola R Naylor1,2, Jack Williams3, Nathan Green4
1Department of Health Services Research and Policy, London School of Hygiene & Tropical Medicine, London, UK. nichola.naylor@lshtm.ac.uk.
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.
Related Concept Videos
Statistical Methods for Analyzing Epidemiological Data
Overview of Microsoft Excel as a Data Analysis Tool
Overview of Biostatistics in Health Sciences
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time...
Microsoft Excel: Regression Analysis
To perform regression...

