Related Experiment Video
Updated: May 22, 2026

Hydra, a Computer-Based Platform for Aiding Clinicians in Cardiovascular Analysis and Diagnosis
Published on: September 26, 2018
[Construction of abridged life table for health evaluation of local resident using Excel program]
Qingsha Chen1, Feng Wang, Xiaozhen Li
1Medical College of Jinan University, Guangzhou, China. tchqsh@jnu.edu.cn
Objective:
To provide an easy computational tool for evaluating the health condition of local residents.
Methods:
An abridged life table was programmed by applying mathematical functions and formula in Excel program and tested with the real study data to evaluate the results computed.
Results:
The Excel was capable of computing group death probability of age in the life table ((n)q(x)), number of survivors (l(x)), number of death ((n)d(x)), survival per person-year ((n)L(x)), survival total per person-year (T(x)) and life expectancy (e(x)). The calculated results were consistent with those by SAS.
Conclusion:
The abridged life table constructed using Microsoft Excel can conveniently and accurately calculate the relevant indices for evaluating the health condition of the residents.
Related Concept Videos
Life Tables
Applications of Life Tables
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time until a...
Actuarial Approach
Consider the example of a high-risk surgical procedure with significant early-stage mortality. A two-year clinical study is conducted,...
Survival Curves
The Kaplan-Meier estimator is the most common method for constructing survival curves. This...
Kaplan-Meier Approach
