About Excel for Fisher exact test.docVIP

 PAGE \* MERGEFORMAT 5 About Excel for Fisher exact test Abstract] gives the Excel spreadsheet with exact method of calculation. Keywords:] Excel spreadsheet; exact probabilities; the actual frequency and theoretical frequency Often in the medical tests conducted case-control study to test between the control group and treatment group there were significant differences, such problems are count data if the original data, data can be organized into the following fourfold table. Table 1 fourfold table Group have some characteristics are not combined with some features of the control group aba + b treatment cdc + d Total a + cb + da + b + c + d In the statistical treatment, according to the sample size n (n = a + b + c + d) the size of the selected statistical method [3]: ① When the sample size ngt; 40, and the theoretical frequency Tgt; 5, the use of χ2 test; ② When ngt; 40, but 1 1 Fisher exact test The test steps are as follows [3]: ① first calculate the actual frequency tables from the number of T0 = | ad-bc | / n; ② to keep in line 4 of Table 1 and 4 of the total value of the same column, so that tables from the data changes, by a series of fourfold table; ③ formula by T0 tables from each of the actual frequency and theoretical absolute value of the difference frequency as Ti; ④ calculated Tigt; = T0 corresponds to the probability of occurrence of fourfold table: Pi = (a + b)! (A + c)! (D + b)! / Ai! Bi! Ci! Di! N! ⑤ that P =  Tigt; = T0Pi ⑥ extrapolate the size of the P. 2 Excel spreadsheets used for operating exact test The following specific examples introduced by the operating steps Example 1 in a pastoral area in patients with chronic Brucella phytohemagglutinin (PHA) skin test reaction, the data shown in Table 2, Q-type and stable activity in patients with or without PHA reflects the difference between positive rates [1]? Table 2, two types of chronic disease of Brucella skin test reaction of PHA