Data Validation and Other Strategies for Data Entry

Kevin A Kupzyk, Marlene Z. Cohen

Research output: Contribution to journalArticle

4 Scopus citations

Abstract

Data entry can result in errors that cause analytic problems and delays in disseminating research. Invalid responses can lead to incorrect statistics and statistical conclusions. The purpose of this article is to provide researchers some basic strategies for avoiding out-of-range data entry errors and streamlining data collection. This article identifies some basic strategies using Microsoft® Excel, which is an inexpensive method of data entry that can be used when research budgets are constrained. Data files can be structured so that out-of-range values cannot be entered. When string variables are entered, researchers may be inconsistent in the way they code responses. Data validation can be accomplished through the use of restricting response options and skipping items can be avoided by using count functions to tabulate the number of valid responses. We also discuss advantages and disadvantages of several methods of data entry, including using web-based data entry and relational databases.

Original languageEnglish (US)
Pages (from-to)546-556
Number of pages11
JournalWestern journal of nursing research
Volume37
Issue number4
DOIs
Publication statusPublished - Apr 16 2015

    Fingerprint

Keywords

  • data entry
  • descriptive quantitative
  • gerontology
  • instrument development
  • methods

ASJC Scopus subject areas

  • Nursing(all)

Cite this