1.Construction of abridged life table for health evaluation of local resident using Excel program.
Qingsha CHEN ; Feng WANG ; Xiaozhen LI ; Jian YANG ; Shouyi YU ; Jun HU
Journal of Southern Medical University 2012;32(5):627-630
OBJECTIVETo provide an easy computational tool for evaluating the health condition of local residents.
METHODSAn 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.
RESULTSThe 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.
CONCLUSIONThe abridged life table constructed using Microsoft Excel can conveniently and accurately calculate the relevant indices for evaluating the health condition of the residents.
Humans ; Life Expectancy ; Life Tables ; Software
Result Analysis
Print
Save
E-mail