Understanding Educational Statistics Using Microsoft Excel and SPSS

  • ID: 1985072
  • August 2011
  • 552 Pages
  • John Wiley and Sons Ltd
1 of 4

Utilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences.

Mobilizing interesting real-world examples from the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and professional alike to present the fundamental statistical practices for organizing, understanding, and drawing conclusions from educational research data.

The book begines with an introduction to descriptive and inferential statistics and then proceeds to acquaint readers with the various functions for working with quantitative data in the Microsoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequent chapters treat the procedures that are commonly-employed when working with data across various fields of social science research, including:

Note: Product cover images may vary from those shown
2 of 4



1 Introduction 1

2 Getting Acquainted with Microsoft Excel.

3 Using Statistics in Excel.

4 SPSSBasics.

5 Descriptive Statistics—Central Tendency.

6 Descriptive Statistics—Variablity.

7 The Normal Distribution.

8 The Z Distribution and Probability.

9 The Nature of Research Design and Inferential Statistics.

10 The T Test for Single Samples.

11 Independent-Samples T Test.

12 Analysis of Variance.

13 Factorial Anova.

14 Correlation.

15 Bivariate Regression.

16 Introduction to Multiple Linear Regression.

17 Chi Square and Contingency Table Analysis.

18 Repeated Measures Procedures: Tdep and ANOVAws.


Appendix: Statistical Tables.


Note: Product cover images may vary from those shown
3 of 4

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

Note: Product cover images may vary from those shown
4 of 4
Note: Product cover images may vary from those shown


  • Quick Help: The book will be shipped to you. The cover has a hard back.


If you have a more general question about our products please try our