Related Experiment Video
Updated: Aug 23, 2025

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data
Published on: December 9, 2015
Health Economic Evaluation Using Markov Models in R for Microsoft Excel Users: A Tutorial
Nathan Green1, Felicity Lamrock2, Nichola Naylor3,4
1Department of Statistical Science, University College London, London, UK.
Abstract:
A health economic evaluation (HEE) is a comparative analysis of alternative courses of action in terms of both costs and consequences. A cost-effectiveness analysis is a type of HEE that compares an intervention to one or more alternatives by estimating how much it costs to gain an additional unit of health outcome. Cost-effectiveness analyses are commonly performed using Microsoft (MS) Excel. However, there is current interest in using other software that is better suited to more complex problems, methods, and data, as well as improved reproducibility and transparency. That is, it is increasingly important to be able to repeat an analysis of a particular data set and obtain the same results, and access the analysis and results in a clear and comprehensive openly available form. In this tutorial we provide a step-by-step guide on how to implement a mainstay model of HEE, namely a Markov model, in the statistical programming language R. The adoption of R for the purpose of cost-effectiveness analysis is highly dependent on the ability of the health economic modeller to understand, learn, and apply programming-type skills. R is likely to be less familiar than MS Excel for many modellers and so coding a cost-effectiveness model in R can be a large jump. We describe the technical details from the perspective of a MS Excel user to help bridge the gap between software and reduce the learning curve by providing for the first-time side-by-side comparisons of the Markov model example in MS Excel and R.
Related Concept Videos
Overview of Microsoft Excel as a Data Analysis Tool
Statistical Methods for Analyzing Epidemiological Data
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time...
Microsoft Excel: Regression Analysis
To perform regression...
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...
Parametric Survival Analysis: Weibull and Exponential Methods
Weibull Distribution
The Weibull distribution is a flexible model used in parametric survival analysis. It can handle both increasing and decreasing hazard rates, depending on its shape parameter...

