Understanding Educational Statistics Using Microsoft Excel and SPSS

by Abbott, Martin Lee

• ISBN13: 9780470889459
• ISBN10: 0470889454
• Edition: 1st
• Format: Hardcover
• Copyright: 2011-09-13
• Publisher: Wiley

Summary

This class-tested book equips readers with the fundamental statistical practices that are essential for organizing, understanding, and drawing conclusions from educational research data. It is the first to utilize both SPSS and Excel to work all problems, examples, and data. Each data procedure is given its own chapter, which concludes with a lab exercise that poses a research question, examines the question by performing that chapters statistical topic of focus in Excel and SPSS, and outlines key findings. This text is meant for courses on introductory statistics in the social sciences at the upper-undergraduate level and as a resource for statistical professionals.

Author Biography

MARTIN LEE ABBOTT, PhD, is Professor of Sociology at Seattle Pacific University, where he also serves as Executive Director of the Washington School Research Center, an independent research and data analysis center funded by the Bill and Melinda Gates Foundation. He has held positions in both academia and in industry, focusing his consulting and teaching in the areas of program evaluation, applied sociology, statistics, and research methods. Dr. Abbott is the author of The Program Evaluation Prism: Using Statistical Methods to Discover Patterns (Wiley).

Table of Contents

Preface
Acknowledgments
Introduction	p. 1
Getting Acquainted with Microsoft Excel
Using Statistics in Excel
SPSSBasics
Descriptive Statistics-Central Tendency
Descriptive Statistics-Variablity
The Normal Distribution
The Z Distribution and Probability
The Nature of Research Design and Inferential Statistics
The T Test for Single Samples
Independent-Samples T Test
Analysis of Variance
Factorial Anova
Correlation
Bivariate Regression
Introduction to Multiple Linear Regression
Chi Square and Contingency Table Analysis
Repeated Measures Procedures: Tdep and ANOVAws
References
Appendix: Statistical Tables
Index.
Table of Contents provided by Publisher. All Rights Reserved.