Multi-State Life Table

Concept

Theoretically, Multi-State Life Table is an extension of the conventional life table that models transitions between multiple mutually exclusive health states over time. It is founded on multi-state survival analysis and Markov process theory and represents the movement of a population between states such as healthy, diseased, disabled and dead. The method exists to estimate life expectancy, health expectancy and disease burden while accounting for competing health states and transition dynamics.

Mathematically, multi-state life tables are represented by state transition probabilities or transition intensity matrices that describe movement between health states over discrete or continuous time. The mathematical framework estimates the expected time spent in each state and the probabilities of occupying each state at future time points.

In practice, multi-state life tables are constructed using epidemiological data on mortality, disease incidence, remission and recovery. Transition probabilities are estimated from longitudinal cohort studies, disease registries or administrative databases. The resulting life tables are used to estimate healthy life expectancy, disability-free life expectancy, years lived with disability and the population impact of health interventions.

---

Purpose

Used to estimate population survival, health expectancy and time spent in multiple health states by modelling transitions between mutually exclusive states over time.

---

Mathematical Formulae

Primary Formula

For a discrete-time multi-state life table:

n???? = n??P

where:

• n?? = population distribution across health states at time t
• P = transition probability matrix
• n???? = population distribution at time t + 1

Supporting Formulae

For continuous-time models, transition intensities are represented by:

P(t) = e??

where:

• Q = transition intensity (generator) matrix
• P(t) = transition probability matrix over time t

Expected time in state i is obtained by summing state occupancy probabilities across the analysis horizon.

Related Mathematical Methods

• Multi-state survival analysis
• Markov models
• Transition probability estimation
• Matrix algebra
• Hazard rate estimation
• Health expectancy modelling

---

Example

A population aged 65 years is classified into three states: healthy, disabled and dead. Annual transition probabilities indicate a 5% probability of moving from healthy to disabled, a 2% probability of dying directly from the healthy state and a 10% annual probability of death from the disabled state. Applying the transition probability matrix across successive years estimates total life expectancy, disability-free life expectancy and expected years lived with disability.

---

Excel Implementation

Function	Example Formula	Health Economics Application
MMULT	=MMULT(B2:D2,$G$2:$I$4)	Projects the population into the next cycle using the transition probability matrix.
SUMPRODUCT	=SUMPRODUCT(B2:D2,$B$1:$D$1)	Calculates expected years or weighted outcomes across health states.
TRANSPOSE	=TRANSPOSE(G2:I4)	Assists with matrix calculations during life table construction.
MINVERSE	=MINVERSE(G2:I4)	Supports advanced matrix operations used in multi-state analyses.

---

VBA (Optional)

Automate multi-cycle state transition calculations and generate life expectancy and health expectancy outputs from transition matrices.

---

Sources

• Briggs A, Claxton K, Sculpher M. Decision Modelling for Health Economic Evaluation. Oxford University Press.
• Chiang CL. The Life Table and Its Applications. Krieger Publishing.
• Rogers A, Ledent J. Multiregional Demography: Principles, Methods and Extensions. Wiley.
• Sullivan DF. A Single Index of Mortality and Morbidity. HSMHA Health Reports. 1971.
• Drummond MF, Sculpher MJ, Claxton K, Stoddart GL, Torrance GW. Methods for the Economic Evaluation of Health Care Programmes. Oxford University Press.