You are here

Creating and Verifying Data Sets with Excel

Creating and Verifying Data Sets with Excel

January 2014 | 184 pages | SAGE Publications, Inc
Accurate data entry and analysis can be deceptively labor-intensive and time-consuming. Creating and Verifying Data Sets with Excel is a focused, easy-to-read guide that gives readers the wherewithal to make use of a remarkable set of data tools tucked within Excel—tools most researchers are entirely unaware of. Robert E. McGrath’s book is the first to focus exclusively on Excel as a data entry system. It incorporates a number of learning tools such as screenshots, text boxes that summarize key points, examples from across the social sciences, tips for creating professional-looking tables, and questions at the end of each chapter. Providing practical strategies to improve and ease the processes of data entry, creation and analysis, this step-by-step guide is a brief, but invaluable resource for both students and researchers.
1. Why This Book?
2. Software Options for Entering Data
3. An Introduction to Excel
4. Data Transformations
5. Data Entry and Verification
6. Data Import and Verification
7. Exporting to Statistical Software
8. Final Thoughts


Data Sets
Data sets for this text are available on the "Preview" tab. Click here to be rerouted.

This book is an effective body of work that combines the best ideas of data sets with Excel in allowing students to maximize the value of such data sets.

Chip Baumgardner
Pennsylvania College of Technology

Excel has become a standard tool in the modern workplace. This well-written and accessible book covers foundational Excel data skills that are rarely taught directly in quantitative methods classes, but that are essential for anyone who aspires to succeed in a data-driven environment.

Kurt Taylor Gaubatz
Old Dominion University

I have been messing around with data for over 40 years, and I still learned useful techniques and tricks from this book. It will be invaluable for everyone doing data analysis, from novices to experts. I highly recommend it.

David L. Streiner
McMaster University

A noteworthy textbook, useful in helping our students get to grips with the basics of data analysis in Microsoft Excel.

Mr Justin Luker
Department of New Media & Technologies, Bucks New University
March 10, 2015

The book was too basic. I'm looking for a book that describes how to do statistical analysis using Excel, preferably with assignments. Thank you for sending this book.

Dr Britta Ricker
Urban Studies, Univ Of Washington-Tacoma
October 27, 2014

The book is valuable and set out well as a practical guide for students. It helps make numbers not so scary. I recommended the book to all students on my research modules from the honours level to masters level.

Ms Bernadette Snow
Development Studies, Nelson Mandela Metropolitan University
August 6, 2014

A very detailed text that offers a great deal of information at a high level of study and somewhat removed from the undergraduate window of practice

Mr Samuel Messam
Sport, Bradford College
June 10, 2014

Robert E. McGrath

Robert McGrath is a Professor of Psychology at Fairleigh Dickinson University. He maintains an active research program in methodology, measurement and assessment, and professional issues in psychology. He has authored over 150 publications and presentations, including the book Quantitative Models in Psychology. He has received a number of awards for his research, including the Society for Personality Assessment’s Martin Mayman Award for distinguished contribution to the literature in personality assessment. Dr. McGrath is a member of the American Psychological Association Council of Representatives, and has even been a candidate for... More About Author

Purchasing options

Please select a format:

ISBN: 9781483331454

SAGE Research Methods is a research methods tool created to help researchers, faculty and students with their research projects. SAGE Research Methods links over 175,000 pages of SAGE’s renowned book, journal and reference content with truly advanced search and discovery tools. Researchers can explore methods concepts to help them design research projects, understand particular methods or identify a new method, conduct their research, and write up their findings. Since SAGE Research Methods focuses on methodology rather than disciplines, it can be used across the social sciences, health sciences, and more.