Design of Autocorrection Data Processing Program for Fourfold Table Chi-square Test Based on Excel / 中国药房

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.