
×
Understanding Educational Statistics Using Microsoft Excel and SPSS
von Martin Lee AbbottUtilizing the latest software, this book presents the essentialstatistical procedures for drawing valuable results from data inthe social sciences.
Mobilizing interesting real-world examples from the field ofeducation, Understanding Educational Statistics Using MicrosoftExcel and SPSS supplies a seamless presentation that identifiesvaluable connections between statistical applications and researchdesign. Class-tested to ensure an accessible presentation, the bookcombines clear, step-by-step explanations and the use of softwarepackages that are accessible to both the novice and professionalalike to present the fundamental statistical practices fororganizing, understanding, and drawing conclusions from educationalresearch data.
The book begines with an introduction to descriptive andinferential statistics and then proceeds to acquaint readers withthe various functions for working with quantitative data in theMicrosoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequentchapters treat the procedures that are commonly-employed whenworking with data across various fields of social science research, including:
* Single-sample tests
* Repeated measure tests
* Independent t-tests
* One way ANOVA and factorial ANOVA
* Correlation
* Bivariate regression
* Chi square
* Multiple regression
Individual chapters are devoted to specific procedures, eachending with a lab exercise that highlights the importance of thatprocedure by posing a research question, examining the questionthrough its application in Excel and SPSS, and concluding with abrief research report that outlines key findings drawn from theresults. Real-world examples and data from modern educationalresearch are used throughout the book, and a related Web sitefeatures additional data sets, examples, and labs, allowing readersto reinforce their comprehension of the material.
Bridging traditional statistical topics with the latest softwareand applications in the field of education, UnderstandingEducational Statistics Using Microsoft Excel and SPSS is anexcellent book for courses on educational research methods andintroductory statistics in the social sciences at theupper-undergraduate and graduate levels. It also serves as avaluable resource for researchers and practitioners in the fieldsof education, psychology, and the social sciences who require astatistical background to work with data in their everydaywork.
Mobilizing interesting real-world examples from the field ofeducation, Understanding Educational Statistics Using MicrosoftExcel and SPSS supplies a seamless presentation that identifiesvaluable connections between statistical applications and researchdesign. Class-tested to ensure an accessible presentation, the bookcombines clear, step-by-step explanations and the use of softwarepackages that are accessible to both the novice and professionalalike to present the fundamental statistical practices fororganizing, understanding, and drawing conclusions from educationalresearch data.
The book begines with an introduction to descriptive andinferential statistics and then proceeds to acquaint readers withthe various functions for working with quantitative data in theMicrosoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequentchapters treat the procedures that are commonly-employed whenworking with data across various fields of social science research, including:
* Single-sample tests
* Repeated measure tests
* Independent t-tests
* One way ANOVA and factorial ANOVA
* Correlation
* Bivariate regression
* Chi square
* Multiple regression
Individual chapters are devoted to specific procedures, eachending with a lab exercise that highlights the importance of thatprocedure by posing a research question, examining the questionthrough its application in Excel and SPSS, and concluding with abrief research report that outlines key findings drawn from theresults. Real-world examples and data from modern educationalresearch are used throughout the book, and a related Web sitefeatures additional data sets, examples, and labs, allowing readersto reinforce their comprehension of the material.
Bridging traditional statistical topics with the latest softwareand applications in the field of education, UnderstandingEducational Statistics Using Microsoft Excel and SPSS is anexcellent book for courses on educational research methods andintroductory statistics in the social sciences at theupper-undergraduate and graduate levels. It also serves as avaluable resource for researchers and practitioners in the fieldsof education, psychology, and the social sciences who require astatistical background to work with data in their everydaywork.