| EXCEL中IF及FREQUENCY函数在血吸虫病资料处理中的应用 |
| |
| 引用本文： | 袁梅枝,王加松,董娟,彭孝武.EXCEL中IF及FREQUENCY函数在血吸虫病资料处理中的应用[J].热带医学杂志,2007,7(9):920-922. |
| |
| 作者姓名： | 袁梅枝 王加松 董娟 彭孝武 |
| |
| 作者单位： | 湖北省荆州市疾病预防控制中心血吸虫病预防控制所,荆州,434000 |
| |
| 摘 要： | 目的对血吸虫病流行村按人群感染率进行分类,统计各类频数。方法采用EXCEL中IF及FREQUENCY函数,对453个村分类并统计各类频数。结果按感染率高低用IF嵌套函数对每个疫区村分类;用FREQUENCY函数分别计算各类村的频数;用FREQUENCY函数,按感染率高低分组,直接计算各组频数。结论采用EXCEL中的IF和FREQUENCY函数,能高效、便捷的对血吸虫病疫情资料进行分类、并统计各类频数。
|
| 关 键 词： | 血吸虫病 分类 频数 IF及FREQUENCY函数 |
| 文章编号： | 1672-3619（2007）09-0920-03 |
| 修稿时间： | 2007-05-14 |
Application of the IF and FREQUENCY Functions of EXCEL Program on Processing Schistosomiasis Data |
| |
| YUAN Mei-zi,WANG Jia-song,DONG Juan,PENG Xiao-wu.Application of the IF and FREQUENCY Functions of EXCEL Program on Processing Schistosomiasis Data[J].Journal Of Tropical Medicine,2007,7(9):920-922. |
| |
| Authors: | YUAN Mei-zi WANG Jia-song DONG Juan PENG Xiao-wu |
| |
| Institution: | Center for Disease Control and Prevention of Juan , PENG Xiao-wu Jingzhou City, Hubei Province, Jingzhou 434000, China |
| |
| Abstract: | Objective To analyze the prevalence of schistosomiasis in the villages.Methods Using IF and FREQUENCY functions of Excel program,classified types and frequency of schistosomiasis pf 453 villages were analyzed.Results 1)Using IF and FREQUENCY functions,affected areas of each village was categorized by the level of infection.2)Frequency of schistosomiasis of each village was calculated using the FREQUENCY function.3)Using the FREQUENCY function,the villages were grouped according high or low rate of infection,and the frequency of schistosomiasis of each group was directly calculated.Conclusion Using IF and FREQUENCY functions of Excel program,the schistosomiasis data can be statistically analyzed effectively. |
| |
| Keywords: | schistosomiasis category frequency IF and FREQUENCY function |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
