Applied statistical analysis for fourfold table data with the worksheet function of Excel
10.3760/cma.j.issn.1000-4955.2011.06.028
- VernacularTitle:Excel工作表函数在四格表资料统计分析中的应用
- Author:
Liu-zhuo, ZHANG
;
Ping, QIN
;
Ang, LI
;
Juan-juan, ZHENG
;
Yuan-jie, SUN
;
Chong-sheng, YUAN
;
Yan, LIU
- Publication Type:Journal Article
- Keywords:
Excel worksheet function;
SAS software;
Fourfold table;
Statistics
- From:Chinese Journal of Endemiology
2011;30(6):694-696
- CountryChina
- Language:Chinese
-
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.
