摘要
目的通过Microsoft Excel实现5种主要的控制图预警模型(休哈特控制图、基于长期基线数据的累积和控制图、基于短期基线数据的累积和控制图、移动平均控制图和指数加权移动平均控制图)。方法利用Excel函数功能计算各种类型控制图的预警统计量和预警上线。结果以宁波市镇海区2006—2011年乙型肝炎每月报告发病数据作为模板,通过Excel表格和图形可以进行传染病预警分析。结论控制图预警模型的Excel程序Excel CC可用于传染病的回顾性和前瞻性时间预警分析。
Objective To implement five major control charts （ including Shewhart control chart, long - time baseline data based cumulative sum control chart, short - time baseline data based cumulative sum control chart, moving average control chart and exponentially weighted moving average control chart） for the early warning of infectious diseases via Microsoft Excel. Methods Statistics and control limits for early warning of the five control charts were calculated by Excelb functions. Results Monthly reported data of hepatitis B during 2006 to 2011 for Zhenhai District of Ningbo City were used as templates, and tables and graphs in Excel were used for early warning analysis of the infectious disease. Conclusion The Excel program Excel CC for control chart warning models can be a useful tool for retrospective and prospective warning analysis of infectious diseases.
出处
《浙江预防医学》
2013年第10期13-17,38,共6页
Zhejiang Journal of Preventive Medicine
基金
国家自然科学基金(31000594)
浙江省教育厅基金(Y200906182)
宁波大学学科项目(XKL11D2123)
关键词
控制图
预警模型
EXCEL
Control charts
Early warning models
Excel
