Preparing Data for Analysis Using Microsoft Excel - …

TOOLS AND ISSUESP reparing data for Analysis Using MicrosoftExcelAlan C. Elliott, Linda S. Hynan, Joan S. Reisch, Janet P. SmithABSTRACTA critical component essential to good research is the accurate andefficient collection and preparation of data for Analysis . Mostmedical researchers have little or no training in data management,often causing not only excessive time spent cleaning data but alsoa risk that the data set contains collection or recording errors. Theimplementation of simple guidelines based on techniques used byprofessional data management teams will save researchers timeand money and result in a data set better suited to answer researchquestions. Because MicrosoftExcelis often used by researchers tocollect data , specific techniques that can be implemented inExcelare Words: data collection, database management system, re-search design, pilot projects, informaticsDuring a presentation at an IBM technicians meeting in1966, a programmer named Wilf Hey coined the phrase Garbage In, Garbage Out.

TOOLS AND ISSUES Preparing Data for Analysis Using Microsoft Excel Alan C. Elliott, Linda S. Hynan, Joan S. Reisch, Janet P. Smith ABSTRACT A critical component essential to good research is the accurate and

Loading..

Tags:

  Analysis, Using, Data, Excel, Microsoft, Preparing, Preparing data for analysis using microsoft excel

Information

Related search queries