EurekaMag
+ Translate
+ Most Popular
Identification of compounds with anti-West Nile Virus activity
Geological age of the Ptilophyllum flora; a critical reassessment
Nira (Co 86032) - a new variety of sugarcane for Maharashtra
Occurrence of Eutrichophilus mexicanus (Rudow, 1866) and Eutrichophilus lobatus (Ewing, 1936) (Phthiraptera: Trichodectidae) on Sphiggurus villosus (Cuvier, 1825) (Rodentia: Erethizontidae) in Rio de
An assessment of water quality of river ganga at garhmukteshwar ghaziabad uttar pradesh india
The identity of the lipstick mold of cultivated mushrooms agaricus bisporus
Comparison of rice bran and maize bran as feeds for growing and fattening pigs
The composition of pampas-grass (Cortaderia argentea.)
Studies on feeding of tapioca thippi (tapioca or cassava starch waste) to swine
Effects of drum rolling on yield of summer groundnut
Integrated farming system for gardenland conditions of Coimbatore district - an over view
Influence of a decision analysis model on selection of drug therapy
Comparative performance of West Coast Tall and Lakshadweep Ordinary cultivars of coconut
Evaluation of WCT coconut and Komadan coconut
Cellars as hibernation sites for bats
Donkioporia expansa - A lesser known wood destroyer in buildings
The Bangla adaptation of Mini-Mental State Examination (BAMSE): An instrument to assess cognitive function in illiterate and literate individuals
Enterobacter amnigenus. An unusual human pathogen
'Rajeshwari' - a high-yielding white seeded variety of sesame for Andhra Pradesh
Gymnosperms of Sikkim, India
The great Coalinga cricket invasion
Psoriasis: correlation between severity index (PASI) and quality of life index (DLQI) in patients assessed before and after systemic treatment
Real-time PCR assays for the specific detection of monkeypox virus West African and Congo Basin strain DNA
Classification of fermented foods: worldwide review of household fermentation techniques
The biology of human starvation: some new insights

Preparing data for analysis using microsoft Excel


Preparing data for analysis using microsoft Excel



Journal of Investigative Medicine: the Official Publication of the American Federation for Clinical Research 54(6): 334-341



ISSN/ISBN: 1081-5589

PMID: 17134617

DOI: 10.2310/6650.2006.05038

A critical component essential to good research is the accurate and efficient collection and preparation of data for analysis. Most medical researchers have little or no training in data management, often causing not only excessive time spent cleaning data but also a risk that the data set contains collection or recording errors. The implementation of simple guidelines based on techniques used by professional data management teams will save researchers time and money and result in a data set better suited to answer research questions. Because Microsoft Excel is often used by researchers to collect data, specific techniques that can be implemented in Excel are presented.

Please choose payment method:






(PDF emailed within 0-6 h: $19.90)

Accession: 049991142

Download citation: RISBibTeXText

Related references

"Utstein style" spreadsheet and database programs based on Microsoft Excel and Microsoft Access software for CPR data management of in-hospital resuscitation. Resuscitation 61(1): 37-40, 2004

Inflexion Automated analysis of radioligand binding data with microsoft Excel. British Journal of Pharmacology 112(Proceedings Suppl. MAY): 440P, 1994

PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel. Computer Methods and Programs in Biomedicine 99(3): 306-314, 2010

AGANTG: a Microsoft EXCEL 5.0-visual basic routine for the analysis of dose-response data. Analyst 123(8): 1661-1668, 1998

A non-linear regression analysis program for describing electrophysiological data with multiple functions using Microsoft Excel. Computer Methods and Programs in Biomedicine 82(1): 51-57, 2006

EeFit: a Microsoft Excel-embedded program for interactive analysis and fitting of experimental dose-response data. Biotechniques 66(4): 186-193, 2019

Monte Carlo simulation of parameter confidence intervals for non-linear regression analysis of biological data using Microsoft Excel. Computer Methods and Programs in Biomedicine 107(2): 155-163, 2012

Limitations of Using Microsoft Excel Version 2016 (MS Excel 2016) for Statistical Analysis for Medical Research. Clinical Spine Surgery 29(5): 203-204, 2016

A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet. Computer Methods and Programs in Biomedicine 65(3): 191-200, 2001

Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis. Bmc Research Notes 5: 52, 2012

PetroPlot: A plotting and data management tool set for Microsoft Excel. Geochemistry, Geophysics, Geosystems 4(3): N/A-N/A, 2003

Simple and Quick Visualization of Periodical Data Using Microsoft Excel. Methods and Protocols 2(4), 2019

How to manage and display qualitative data using "Framework" and Microsoft Excel. Journal of Clinical Nursing 12(4): 610-612, 2003

Using macros in microsoft excel to facilitate cleaning of research data. Journal of Community Hospital Internal Medicine Perspectives 11(5): 653-657, 2021

Using Microsoft Excel® to Build a Customized Partial-Interval Data Collection System. Behavior Analysis in Practice 11(4): 504-516, 2018