Creating and Verifying Data Sets with Excel
- Robert E. McGrath - Fairleigh Dickinson University, USA
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
A noteworthy textbook, useful in helping our students get to grips with the basics of data analysis in Microsoft Excel.
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.
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.
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
Sport, Bradford College
June 10, 2014