Data Validation and Other Strategies for Data Entry

Kevin A. Kupzyk, Marlene Z. Cohen

Research output: Contribution to journalArticlepeer-review

10 Scopus citations


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
Issue number4
StatePublished - Apr 16 2015


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

ASJC Scopus subject areas

  • General Nursing


Dive into the research topics of 'Data Validation and Other Strategies for Data Entry'. Together they form a unique fingerprint.

Cite this