title: Use of Spreadsheets for Research Data Collection and Preparation: A Primer.
abstract: Successful research results from the combination of multiple elements, including an appropriate research question, study design, research method, statistical analysis, and interpretation of results. One element of research that is easy to overlook is proper data collection and preparation for analysis. If data collection or preparation is inadequately planned or executed, the data may not be analyzable by a statistician without significant effort spent on data cleaning. Even worse, the data may contain problems that can be resolved only through time-consuming revision or repeat data collection. In this review, we present some practical guidelines and best practices for preparing data that can reduce the work of subsequent analysis.
authors.affiliation: Department of Radiology, Memorial Sloan Kettering Cancer Center, New York, NY, USA. Electronic address: juluruk@mskcc.org.
authors.forename: Krishna
authors.initials: K
authors.lastname: Juluru
authors.affiliation: Russell H. Morgan Department of Radiology and Radiological Science, Johns Hopkins University School of Medicine, Baltimore, MD, USA.
authors.forename: John
authors.initials: J
authors.lastname: Eng
mesh_terms: D003625:Data Collection / Q000379:methods* / Q000592:standards*; D003627:Data Interpretation, Statistical; D017408:Guidelines as Topic; D006801:Humans; D012107:Research Design / Q000592:standards*; D012984:Software
keywords: HIPAA; PHI; Research methodology; Spreadsheets; Statistical analysis