Journal of Postgraduate Medicine, Education and Research

Register      Login

VOLUME 53 , ISSUE 4 ( October-December, 2019 ) > List of Articles

BIOSTATISTICS SERIES

Statistics Corner: Data Cleaning-II

Citation Information : Statistics Corner: Data Cleaning-II. J Postgrad Med Edu Res 2019; 53 (4):164-167.

DOI: 10.5005/jp-journals-10028-1339

License: CC BY-NC 4.0

Published Online: 01-06-2018

Copyright Statement:  Copyright © 2019; The Author(s).


Abstract

Reality check Microsoft Excel is one of the most routinely used spreadsheets to enter and clean data by researchers. However, the lack of professional training in Excel hinder its efficient usage. Majority of investigators are aware of basic data entry and cleaning mechanisms in Excel. However, there are numerous advanced easy-to-use functions that increase the efficiency and accuracy of data entry. The present article will be discussing four vital functions to enter and clean data efficiently. These functions are the following: • Data form • Data validation • Go to special • Protecting specific columns, worksheet, and workbook


HTML PDF Share
  1. Ripley BD. Statistical methods need software: a view of statistical computing. In: Presentation RSS Meeting; 2002.
  2. Mélard G. On the accuracy of statistical procedures in Microsoft Excel 2010. Comput Stat 2014;29(5):1095–1128.
  3. McCullough BD. Special section on Microsoft Excel 2007. Comput Stat Data Anal 2008;52(10):4568–4569.
  4. Elliott AC, Hynan LS, Reisch JS, et al. Preparing data for analysis using Microsoft Excel. J Investig Med 2006;54(6):334–341. DOI: 10.2310/6650.2006.05038.
  5. Kishore K, Kapoor R, Singh A. Statistics corner: data cleaning-I. J Postgrad Med Educ Res 2019;53(3):130–132.
  6. Ziemann M, Eren Y, El-Osta A. Gene name errors are widespread in the scientific literature. Genome Biol 2016;17(1):177. DOI: 10.1186/s13059-016-1044-7.
  7. Zeeberg BR, Riss J, Kane DW, et al. Mistaken identifiers: gene name errors can be introduced inadvertently when using Excel in bioinformatics. BMC Bioinformatics 2004;5:80. DOI: 10.1186/1471-2105-5-80.
PDF Share
PDF Share

© Jaypee Brothers Medical Publishers (P) LTD.