Applied statistical analysis for fourfold table data with the worksheet function of Excel / 中国地方病学杂志

ABSTRACT

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.