Design of Autocorrection Data Processing Program for Fourfold Table Chi-square Test Based on Excel
- VernacularTitle:利用Excel软件建立四格表?~2检验自动校正处理程序
- Author:
Huaiyu SU
- Publication Type:Journal Article
- Keywords:
Excel;
Chi-square test;
Actual frequency;
Theoretical frequency;
Fisher's exact test
- From:
China Pharmacy
2007;0(28):-
- CountryChina
- Language:Chinese
-
Abstract:
OBJECTIVE:To develop autocorrection data processing program for fourfold table Chi-square test program based on Excel.METHODS:Formatted fourfold table Chi-square test auto-analyzer procedure was established based on Excel.If total samples were no less than 40 and the theoretical frequency was no less than 1,Chi-square value and probability value could be obtained by using Pearson's Chi-square formula and Yates' Chi-square correction formula,otherwise,the values will be calculated by revising form cell citation based on Fisher's exact test.RESULTS & CONCLUSIONS:Fourfold Chi-square test can be realized based on Excel,furthermore,once formatted worksheet is fixed,Chi Square value can be obtained as long as sample values in worksheet are replaced.
