Provides a step-by-step approach to statistical procedures to analyze data and conduct research, with detailed sections in each chapter explaining SPSS(R) and Excel(R) applications This book identifies connections between statistical applications and research design using cases, examples, and discussion of specific topics from the social and health sciences. Researched and class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations for both the novice and professional alike to understand the fundamental statistical practices for organizing, analyzing, and drawing conclusions from research data in their field. The book begins with an introduction to descriptive and inferential statistics and then acquaints readers with important features of statistical applications (SPSS and Excel) that support statistical analysis and decision making. Subsequent chapters treat the procedures commonly employed when working with data across various fields of social science research. Individual chapters are devoted to specific statistical procedures, each ending with lab application exercises that pose research questions, examine the questions through their application in SPSS and Excel, and conclude with a brief research report that outlines key findings drawn from the results. Real-world examples and data from social and health sciences research are used throughout the book, allowing readers to reinforce their comprehension of the material. Using Statistics in the Social and Health Sciences with SPSS(R) and Excel(R) includes: Use of straightforward procedures and examples that help students focus on understanding of analysis and interpretation of findings Inclusion of a data lab section in each chapter that provides relevant, clear examples Introduction to advanced statistical procedures in chapter sections (e.g., regression diagnostics) and separate chapters (e.g., multiple linear regression) for greater relevance to real-world research needs Emphasizing applied statistical analyses, this book can serve as the primary text in undergraduate and graduate university courses within departments of sociology, psychology, urban studies, health sciences, and public health, as well as other related departments. It will also be useful to statistics practitioners through extended sections using SPSS(R) and Excel(R) for analyzing data. Martin Lee Abbott, PhD, is Professor of Sociology at Seattle Pacific University, where he has served as Executive Director of the Washington School Research Center, an independent research and data analysis center funded by the Bill & Melinda Gates Foundation. Dr. Abbott has held positions in both academia and industry, focusing his consulting and teaching in the areas of statistical procedures, program evaluation, applied sociology, and research methods. He is the author of Understanding Educational Statistics Using Microsoft Excel(R) and SPSS(R), The Program Evaluation Prism: Using Statistical Methods to Discover Patterns, and Understanding and Applying Research Design, also from Wiley.

This book is a comprehensive treatment of correlation/regression techniques and using SPSS for interpretation of findings. Striking a balance between detailed coverage and approachability, this book provides a thorough treatment of the elements of regression and how they can be used with real research problems in program evaluation.

The author begins with a basic introduction to evaluation methodology, and its ability to recognize embedded patterns of meaning in research data. Subsequent chapters explore the statistical tools that can be applied by researchers and evaluators irrespective of the design that was used to generate this data.

Topics of coverage include: correlation, single predictor regression, multiple correlation, part and partial correlation, detection of extreme scores, multiple regression, regression with continuous predictors, coding of categorical data, regression with categorical predictors, methods for entering predictors in multiple regression, and interaction in multiple regression.

Each chapter is presented in the same comprehensive format: an introduction to the topic, followed by a discussion of its primary elements, illustrations of the data through numerous tables and figures, SPSS procedures for designing the analysis, SPSS output of the analysis, and guidance on how to interpret findings from the analyses. "Discover Note" and "Research Steps" sections illustrate how using statistical processes can unveil unobserved patterns and assist readers with identifying such patterns in their own data.

Real-world analyses are used throughout the book, utilizing meaningful social issues as a catalyst for teaching statistical procedures, and a related Web site features additional data sets, solutions, and research projects for readers.

A fresh approach to bridging research design with statistical analysis

While good social science requires both research design and statistical analysis, most books treat these two areas separately." Understanding and Applying Research Design" introduces an accessible approach to integrating design and statistics, focusing on the processes of posing, testing, and interpreting research questions in the social sciences.

The authors analyze real-world data using SPSS software, guiding readers on the overall process of science, focusing on premises, procedures, and designs of social scientific research. Three clearly organized sections move seamlessly from theoretical topics to statistical techniques at the heart of research procedures, and finally, to practical application of research design: Premises of Research introduces the research process and the capabilities of SPSS, with coverage of ethics, Empirical Generalization, and Chi Square and Contingency Table AnalysisProcedures of Research explores key quantitative methods in research design including measurement, correlation, regression, and causationDesigns of Research outlines various design frameworks, with discussion of survey research, aggregate research, and experiments

Throughout the book, SPSS software is used to showcase the discussed techniques, and detailed appendices provide guidance on key statistical procedures and tips for data management. Numerous exercises allow readers to test their comprehension of the presented material, and a related website features additional data sets and SPSS code.

"Understanding and Applying Research Design" is an excellent book for social sciences and education courses on research methods at the upper-undergraduate level. The book is also an insightful reference for professionals who would like to learn how to pose, test, and interpret research questions with confidence.

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 testsRepeated measure testsIndependent t-testsOne way ANOVA and factorial ANOVACorrelationBivariate regressionChi squareMultiple 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.