南方医科大学学报2012，Vol.32Issue(5)：627-630,4.DOI:10.3969/j.issn.1673-4254.2012.05.008
简略寿命表Excel程序的编制及在居民健康状况评价中的应用
Construction of abridged life table for health evaluation of local resident using Excel program
摘要
Abstract
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 (nq,).number of survivors (lz),number of death (dz),survival per person-year (L,),survival total per person-year (T,) and life expectancy (e,).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.关键词
Excel/程序/居民健康/寿命表/死亡概率/预期寿命Key words
Excel/calculator program/abridged life table/life expectancy分类
医药卫生引用本文复制引用
陈青山,王锋,李晓珍,杨剑,俞守义,胡军..简略寿命表Excel程序的编制及在居民健康状况评价中的应用[J].南方医科大学学报,2012,32(5):627-630,4.基金项目
国家继续医学教育项目(20101205019) （20101205019）
辽宁省自然科学基金(20101126) （20101126）
