Microsoft Excel add-in for the statistical analysis of contingency tables

Peter Slezák; Pavol Bokes; Pavol Námer; Iveta Waczulíková

doi:10.31686/ijier.vol2.iss5.188

Authors

Peter Slezák Comenius University, Slovakia
Pavol Bokes Comenius University, Slovakia
Pavol Námer Comenius University, Slovakia
Iveta Waczulíková Comenius University, Slovakia

DOI:

https://doi.org/10.31686/ijier.vol2.iss5.188

Abstract

This paper introduces “Contingency table analysis”, a freely available menu-driven add-in program for Microsoft EXCEL, written in Visual Basic for Applications (VBA), for basic univariate and bivariate statistical analyses of contingency tables. The program provides modules for the statistical analysis of proportions, 2 × 2 tables, stratified 2 × 2 tables, and R × C tables. We compare the results of the analyses performed using our software with those obtained by commercially available statistical software. The comparison shows that our software performs equally well. The use of the add-in facilitates the convenient prosecution of basic statistical analyses on contingency tables from within EXCEL, sparing us the additional cost, or the inconvenience of alternating between multiple platforms, often incurred in using a commercial statistical package.

Downloads

Download data is not yet available.

Author Biographies

Peter Slezák, Comenius University, Slovakia

Institute of Simulation and Virtual Medical Education, Faculty of Medicine
Pavol Bokes, Comenius University, Slovakia

Department of Applied Mathematics and Statistics, Faculty of Mathematics, Physics and Informatics
Pavol Námer, Comenius University, Slovakia

Polymer Institute, Slovak Academy of Sciences
Iveta Waczulíková, Comenius University, Slovakia

Division of Biomedical Physics, Faculty of Mathematics, Physics and Informatics

References

P.P. Gomes, L.A. Passeri, J.R. Barbosa, A 5-year retrospective study of zygomatico-orbital complex and zygomatic arch fractures in Sao Paulo State, Brazil, J. Oral Maxillofac. Surg. 64 (2006) 63–67. DOI: https://doi.org/10.1016/j.joms.2005.09.012

P.S. Craighead, K. Sait, G.C. Stuart, K. Arthur, J. Nation, M. Duggan, D. Guo, Management of aggressive histologic variants of endometrial carcinoma at the Tom Baker Cancer Center between 1984 and 1994, Gynecol. Oncol. 77 (2000) 248–253. DOI: https://doi.org/10.1006/gyno.2000.5746

R. Achuthan, K. Grover, F. MacFie, Critical evaluation of the electronic surgical logbook, BMC Med. Edu. 6 (2006) 15. DOI: https://doi.org/10.1186/1472-6920-6-15

R. Glazebrook, B. Chater, P. Graham, et al., Evaluation of the ACRRM national radiology program for Australian rural and remote medical practitioners, Rural Remote Health 5 (2005) 349. DOI: https://doi.org/10.22605/RRH349

H. Sato, S. Sato, Y.M. Wang, I. Horikoshi, Add-in macros for rapid and versatile calculation of non-compartmental pharmacokinetic parameters on Microsoft Excel spreadsheets, Comput. Meth. Prog. Biomed. 50 (1996) 43–52. DOI: https://doi.org/10.1016/0169-2607(96)01730-0

C. Dansirikul, M. Choi, S.B. Duffull, Estimation of pharmacokinetic parameters from non-compartmental variables using Microsoft Excel, Comput. Biol. Med. 35 (2005) 389–403. DOI: https://doi.org/10.1016/j.compbiomed.2004.02.008

H.A. Khan, ArrayVigil: a methodology for statistical comparison of gene signatures using segregated-one-tailed (SOT) Wilcoxon signed-rank test, J. Mol. Biol. 345 (2005) 645–649. DOI: https://doi.org/10.1016/j.jmb.2004.11.018

H.A. Khan, ArraySolver: an algorithm for color-coded graphical display and Wilcoxon signed-rank statistics for comparing microarray gene expression data, Comput. Func. Genom. 5 (2004) 39–47. DOI: https://doi.org/10.1002/cfg.369

A.M. Brown, A spreadsheet template compatible with Microsoft Excel and iWork Numbers that returns the simultaneous confidence intervals for all pairwise differences between multiple sample means. Comput. Meth. Prog. Biomed. 98 (2010)76–82. DOI: https://doi.org/10.1016/j.cmpb.2009.10.001

H.A. Khan, SCEW: A Microsoft Excel add-in for easy creation of survival curves, Comput. Meth. Prog. Biomed. 83 (2006) 12–17. DOI: https://doi.org/10.1016/j.cmpb.2006.05.001

A. Agresti, An Introduction to Categorical DataAnalysis (2nd ed.), Wiley-Interscience, (2007). DOI: https://doi.org/10.1002/0470114754

J.H. Zar, Biostatistical Analysis (5th ed.), Pearson Prentice-Hall, (2010).

W.G. Cochran, The χ2 Test of Goodness of Fit, Ann. Math. Statist. 23 (1952) 315-491.[14] P. Armitage, Tests for Linear Trends in Proportions and Frequencies, Biometrics 11 (1955) 375–386. DOI: https://doi.org/10.1214/aoms/1177729380

D. Zelterman, Models for Discrete Data, Oxford University Press (2006).

J.L. Fleiss, B. Levin, M.C. Paik, Statistical Methods for Rates and Proportions (3rd ed.), Wiley (2003). DOI: https://doi.org/10.1002/0471445428

A.E. Maxwell, Analysing Qualitative Data, Methuen (1961) p34.

D.I. Tudehope, J. Iredell, D. Rodgers and A. Gunn, Neonatal death: grieving families, Med. J. Aust. 144 (1986) 290-292 DOI: https://doi.org/10.5694/j.1326-5377.1986.tb128376.x

L. Rosenberg, D. Slone, S. Shapiro, D.W. Kaufman, P.D. Stolley, and O.S. Miettinen, Coffee drinking and myocardial infarction in young women, Am. J. Epidemiol., 111 (1980) 675–681. DOI: https://doi.org/10.1093/oxfordjournals.aje.a112945