Understanding educational statistics using Microsoft Excel and SPSS

著者

    • Abbott, Martin Lee

書誌事項

Understanding educational statistics using Microsoft Excel and SPSS

Martin Lee Abbott

Wiley, c2011

電子リソースにアクセスする 全1件

大学図書館所蔵 件 / 全3件

この図書・雑誌をさがす

注記

"A John Wiley & Sons, Inc., publication"

Includes bibliographical references (p. 511-512) and index

内容説明・目次

内容説明

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: 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, each ending with a lab exercise that highlights the importance of that procedure by posing a research question, examining the question through its application in Excel and SPSS, and concluding with a brief research report that outlines key findings drawn from the results. Real-world examples and data from modern educational research are used throughout the book, and a related Web site features additional data sets, examples, and labs, allowing readers to reinforce their comprehension of the material. Bridging traditional statistical topics with the latest software and applications in the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS is an excellent book for courses on educational research methods and introductory statistics in the social sciences at the upper-undergraduate and graduate levels. It also serves as a valuable resource for researchers and practitioners in the fields of education, psychology, and the social sciences who require a statistical background to work with data in their everyday work.

目次

Preface xix Acknowledgments xxi 1 Introduction 1 2 Getting Acquainted with Microsoft Excel1 7 3 Using Statistics in Excel1 17 4 SPSS1 Basics 23 5 Descriptive Statistics-Central Tendency 41 6 Descriptive Statistics-Variablity 81 7 The Normal Distribution 101 8 The Z Distribution and Probability 127 9 The Nature of Research Design and Inferential Statistics 147 10 The T Test for Single Samples 175 11 Independent-Samples T Test 209 12 Analysis of Variance 257 13 Factorial Anova 307 14 Correlation 337 15 Bivariate Regression 383 16 Introduction to Multiple Linear Regression 429 17 Chi Square and Contingency Table Analysis 453 18 Repeated Measures Procedures: Tdep and ANOVAws 489 References 511 Appendix: Statistical Tables 513 Index 523

「Nielsen BookData」 より

詳細情報

ページトップへ