Creating and Verifying Data Sets with Excel / Edition 1

by Robert E. McGrath

Overview

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. Mc Grath’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.

"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, Mc Master University

“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 are essential for anyone who aspires to succeed in a data-driven environment.”

—Kurt Taylor Gaubatz, Old Dominion University

Product Details

ISBN-13:	9781483331454
Publisher:	SAGE Publications
Publication date:	01/28/2014
Pages:	184
Product dimensions:	9.70(w) x 12.00(h) x 0.70(d)

About the Author

Robert Mc Grath 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. Mc Grath is a member of the American Psychological Association Council of Representatives, and has even been a candidate for president of the APA. He lost. When not occupied otherwise, he has also helped found two community organizations in his home town of Warwick NY addressing issues of land preservation and environmental sustainability.

Table of Contents

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

Editorial Reviews

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

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

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