title: Limitations of Using Microsoft Excel Version 2016 (MS Excel 2016) for Statistical Analysis for Medical Research.
abstract: Microsoft Excel (MS Excel) is a commonly used program for data collection and statistical analysis in biomedical research. However, this program has many limitations, including fewer functions that can be used for analysis and a limited number of total cells compared with dedicated statistical programs. MS Excel cannot complete analyses with blank cells, and cells must be selected manually for analysis. In addition, it requires multiple steps of data transformation and formulas to plot survival analysis graphs, among others. The Megastat add-on program, which will be supported by MS Excel 2016 soon, would eliminate some limitations of using statistic formulas within MS Excel.
authors.affiliation: *Department of Orthopedic Surgery, Faculty of Medicine, King Chulalongkorn Memorial Hospital†Department of Orthopedic Surgery, Faculty of Medicine Siriraj Hospital, Mahidol University, Bangkok, Thailand.
authors.forename: Chotetawan
authors.initials: C
authors.lastname: Tanavalee
authors.forename: Panya
authors.initials: P
authors.lastname: Luksanapruksa
authors.forename: Weerasak
authors.initials: W
authors.lastname: Singhatanadgige
mesh_terms: D035843:Biomedical Research / Q000379:methods / Q000706:statistics & numerical data*; D019295:Computational Biology; D003627:Data Interpretation, Statistical; D003628:Database Management Systems; D006801:Humans; D011381:Programming Languages; D016019:Survival Analysis