Microsoft Excel add-in for the statistical analysis of contingency tables
DOI:
https://doi.org/10.31686/ijier.vol2.iss5.188Abstract
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.
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
Downloads
Published
Issue
Section
License
Copyright (c) 2014 Peter Slezák, Pavol Bokes, Pavol Námer, Iveta Waczulíková
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License.
Copyrights for articles published in IJIER journals are retained by the authors, with first publication rights granted to the journal. The journal/publisher is not responsible for subsequent uses of the work. It is the author's responsibility to bring an infringement action if so desired by the author for more visit Copyright & License.
How to Cite
