CAJ | 학술논문

目的利用Excel工作表函数实现四格表资料的统计分析过程,以提高广大科研工作者对Excel统计功能的认知.方法用《中国地方病学杂志》中的实际研究结果做数据源,对比Excel和SAS两种软件对四格表资料的统计分析结果.结果 Excel工作表函数可实现四格表资料的x2检验过程,且并非只是P＞ 0.05或P＜ 0.05的结果,而是得到P值的准确数值.两种软件x2检验的分析结果一致,但Excel不能获得SAS中的fisher确切概率法结果.结论作为依附型的统计分析软件,Excel是一个易学、易用、高效的好帮手,在没有专业统计分析软件的情况下,Excel可实现资料的统计学分析过程.
목적 이용Excel공작표함수실현사격표자료적통계분석과정,이제고엄대과연공작자대Excel통계공능적인지.방법 용《중국지방병학잡지》중적실제연구결과주수거원,대비Excel화SAS량충연건대사격표자료적통계분석결과.결과 Excel공작표함수가실현사격표자료적x2검험과정,차병비지시P＞ 0.05혹P＜ 0.05적결과,이시득도P치적준학수치.량충연건x2검험적분석결과일치,단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.