摘要目的 利用Excel工作表函数实现四格表资料的统计分析过程,以提高广大科研工作者对Excel统计功能的认知.方法 用《中国地方病学杂志》中的实际研究结果做数据源,对比Excel和SAS两种软件对四格表资料的统计分析结果.结果 Excel工作表函数可实现四格表资料的x2检验过程,且并非只是P＞ 0.05或P＜ 0.05的结果,而是得到P值的准确数值.两种软件x2检验的分析结果一致,但Excel不能获得SAS中的fisher确切概率法结果.结论 作为依附型的统计分析软件,Excel是一个易学、易用、高效的好帮手,在没有专业统计分析软件的情况下,Excel可实现资料的统计学分析过程.

abstractsObjective 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.