Construction of abridged life table for health evaluation of local resident using Excel program / 南方医科大学学报

ABSTRACT

<p><b>OBJECTIVE</b>To provide an easy computational tool for evaluating the health condition of local residents.</p><p><b>METHODS</b>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.</p><p><b>RESULTS</b>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.</p><p><b>CONCLUSION</b>The abridged life table constructed using Microsoft Excel can conveniently and accurately calculate the relevant indices for evaluating the health condition of the residents.</p>