Creating and Verifying Data Sets with Excel

Robert E. McGrath - Fairleigh Dickinson University, USA
Creating and Verifying Data Sets with Excel
January 2014 | 184 pages | Sage US
Create Flyer

If you’re in the Americas, please visit our Sage College Publishing website to purchase or sample this book:

Go to College Publishing Website

Description

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.

Contents

1. Why This Book?

1. Why This Book?

2. Software Options for Entering Data

2. Software Options for Entering Data

3. An Introduction to Excel

3. An Introduction to Excel

4. Data Transformations

4. Data Transformations

5. Data Entry and Verification

5. Data Entry and Verification

6. Data Import and Verification

6. Data Import and Verification

7. Exporting to Statistical Software

7. Exporting to Statistical Software

8. Final Thoughts

8. Final Thoughts

Description

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.

Contents

1. Why This Book?

1. Why This Book?

2. Software Options for Entering Data

2. Software Options for Entering Data

3. An Introduction to Excel

3. An Introduction to Excel

4. Data Transformations

4. Data Transformations

5. Data Entry and Verification

5. Data Entry and Verification

6. Data Import and Verification

6. Data Import and Verification

7. Exporting to Statistical Software

7. Exporting to Statistical Software

8. Final Thoughts

8. Final Thoughts

SAGE Publishing Logo

Creating and Verifying Data Sets with Excel

Robert E. McGrath
Cancel Print

January 2014 | 184 pages | Sage US

Format Published Date ISBN Price

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.


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

Recent Product Reviews:

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
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
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
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
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

Recommendations