Excel工作表函数在四格表资料统计分析中的应用  

Applied statistical analysis for fourfold table data with the worksheet function of Excel

作　　者：张镏琢[1] 秦平[1] 李昂[1] 郑娟娟[1] 孙远洁[1] 袁重胜[2] 刘艳[1] 

机构地区：[1]哈尔滨医科大学公共卫生学院卫生统计学教研室,150081 [2]哈尔滨医科大学公共卫生学院研究生学院,150081

出　　处：《中国地方病学杂志》2011年第6期694-696,共3页Chinese Jouranl of Endemiology

基　　金：国家自然科学基金（30972537）

摘　　要：目的利用Excel工作表函数实现四格表资料的统计分析过程，以提高广大科研工作者对Excel统计功能的认知。方法用《中国地方病学杂志》中的实际研究结果做数据源，对比Excel和SAS两种软件对四格表资料的统计分析结果。结果Excel工作表函数可实现四格表资料的χ^2检验过程，且并非只是P〉0．05或P〈0．05的结果，而是得到P值的准确数值。两种软件χ^2检验的分析结果一致，但Excel不能获得SAS中的fisher确切概率法结果。结论作为依附型的统计分析软件，Excel是一个易学、易用、高效的好帮手，在没有专业统计分析软件的情况下，Excel可实现资料的统计学分析过程。Objective To use Excel worksheet function to achieve statistical analysis of the fourfold table qualitative data, and to improve knowledge of the majority of researchers on the statistical capabilities of Excel. Methods The result of actual research published in Chinese Journal of Endemiology was the data source, and statistical analysis results of fourfold table data from Excel and from SAS software were contrasted. Results The worksheet function of Excel could realize the analysis fourfold table data chi-square test, obtained an accurate P values, but not just P 〉 0.05 or P 〈 0.05. The results of chi-square test of Excel were the same as the results from SAS software, but Excel could not obtain probability value of fisher exact probability. Conclusion As a dependent statistical analysis software, Excel is an easy to learn, easy to use, efficient and a good helper. In the absence of professional statistical software, Excel can be used to achieve data statistical analysis.

关 键 词：Excel工作表函数 SAS软件 四格表 统计学 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]