Use of Spreadsheets for Research Data Collection and Preparation: A Primer

Krishna Juluru, John Eng

Research output: Contribution to journalArticle

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.

Original languageEnglish (US)
Pages (from-to)1592-1599
Number of pages8
JournalAcademic Radiology
Volume22
Issue number12
DOIs
StatePublished - Dec 1 2015

Fingerprint

Research
Practice Guidelines
Research Design
Guidelines

Keywords

  • HIPAA
  • PHI
  • Research methodology
  • Spreadsheets
  • Statistical analysis

ASJC Scopus subject areas

  • Radiology Nuclear Medicine and imaging

Cite this

Use of Spreadsheets for Research Data Collection and Preparation : A Primer. / Juluru, Krishna; Eng, John.

In: Academic Radiology, Vol. 22, No. 12, 01.12.2015, p. 1592-1599.

Research output: Contribution to journalArticle

@article{efda693a6fdf4f0bb6f3e6a2e220a109,
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.",
keywords = "HIPAA, PHI, Research methodology, Spreadsheets, Statistical analysis",
author = "Krishna Juluru and John Eng",
year = "2015",
month = "12",
day = "1",
doi = "10.1016/j.acra.2015.08.024",
language = "English (US)",
volume = "22",
pages = "1592--1599",
journal = "Academic Radiology",
issn = "1076-6332",
publisher = "Elsevier USA",
number = "12",

}

TY - JOUR

T1 - Use of Spreadsheets for Research Data Collection and Preparation

T2 - A Primer

AU - Juluru, Krishna

AU - Eng, John

PY - 2015/12/1

Y1 - 2015/12/1

N2 - 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.

AB - 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.

KW - HIPAA

KW - PHI

KW - Research methodology

KW - Spreadsheets

KW - Statistical analysis

UR - http://www.scopus.com/inward/record.url?scp=84948694937&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84948694937&partnerID=8YFLogxK

U2 - 10.1016/j.acra.2015.08.024

DO - 10.1016/j.acra.2015.08.024

M3 - Article

C2 - 26454810

AN - SCOPUS:84948694937

VL - 22

SP - 1592

EP - 1599

JO - Academic Radiology

JF - Academic Radiology

SN - 1076-6332

IS - 12

ER -