title: [Application of Excel programs of Fisher exact probability test for medical data].
abstract: OBJECTIVE
  To accomplish the computation of Fisher exact probability test for fourfold table data in Excel.
  
  
  METHODS
  The computing program of exact probability method for medical data in fourfold table design was edited by employing the IF statement and the relevant functions, such as SUM, FACT, DSUM, etc in Excel. The computational results are compared and evaluated according to the case studies.
  
  
  RESULTS
  The output of Fisher Exact Probability was generated and presented correctly following the input of four numerical values into the computation program in the setting of Excel. The parametric outcomes are in agreement with those produced by SAS and SPSS, in the combination tables containing the P value, two-tailed cumulative P value, left-tailed P-value, right-tailed P-value, Chi2 values and P values both for direct Chi-squared test and corrected Chi-squared test.
  
  
  CONCLUSIONS
  Direct Chi-squared test, corrected Chi-squared test combined with Fisher Exact Probability test for fourfold table data can be conveniently, rapidly, and accurately accomplished in Excel.
authors.affiliation: Epidemiology Division, Public Heath and Tropical Medicine College, Southern Medical University, Guangzhou 510515, China. tchqsh@jnu.edu.cn
authors.forename: Qing-shan
authors.initials: QS
authors.lastname: Chen
authors.forename: Wei
authors.initials: W
authors.lastname: Wang
authors.forename: Pei-xian
authors.initials: PX
authors.lastname: Lin
authors.forename: Qian-hong
authors.initials: QH
authors.lastname: Zhong
authors.forename: Shou-yi
authors.initials: SY
authors.lastname: Yu
mesh_terms: D008490:Medical Informatics; D011336:Probability; D012984:Software