Statistics for Exercise Science and Health with Microsoft Office Excel

Learn statistical methods quickly and easily with the discovery method With its emphasis on the discovery method, this publication encourages readers to discover solutions on their own rather than simply copy answers or apply a formula by rote. Readers quickly master and learn to apply statistical methods, such as bootstrap, decision trees, t-test, and permutations to better characterize, report, test, and classify their research findings. In addition to traditional methods, specialized methods are covered, allowing readers to select and apply the most effective method for their research, including: * Tests and estimation procedures for one, two, and multiple samples * Model building * Multivariate analysis * Complex experimental design Throughout the text, Microsoft Office Excel(r) is used to illustrate new concepts and assist readers in completing exercises. An Excel Primer is included as an Appendix for readers who need to learn or brush up on their Excel skills. Written in an informal, highly accessible style, this text is an excellent guide to descriptive statistics, estimation, testing hypotheses, and model building. All the pedagogical tools needed to facilitate quick learning are provided: * More than 100 exercises scattered throughout the text stimulate readers' thinking and actively engage them in applying their newfound skills * Companion FTP site provides access to all data sets discussed in the text * An Instructor's Manual is available upon request from the publisher * Dozens of thought-provoking questions in the final chapter assist readers in applying statistics to solve real-life problems * Helpful appendices include an index to Excel and Excel add-in functions This text serves as an excellent introduction to statistics for students in all disciplines. The accessible style and focus on real-life problem solving are perfectly suited to both students and practitioners.

Provides a step-by-step approach to statistical procedures to analyze data and conduct research, with detailed sections in each chapter explaining SPSS® and Excel® 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® and Excel® 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® and Excel® 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® and SPSS®, The Program Evaluation Prism: Using Statistical Methods to Discover Patterns, and Understanding and Applying Research Design, also from Wiley.

A practical and methodological approach to the statistical logic of biostatistics in the field of health research Focusing on a basic understanding of the methods and analyses in health research, Introduction to Biostatistical Applications in Health Research with Microsoft® Office Excel® provides statistical concepts for interpreting results using Excel. The book emphasizes the application of methods and presents the most common methodological procedures in health research, which includes multiple regression, ANOVA, ANCOVA, logistic regression, Cox regression, stratified analysis, life table analysis, and nonparametric parallels. The book is constructed around a flowchart that outlines the appropriate circumstances for selecting a method to analyze a specific set of data. Beginning with an introduction to the foundational methods of statistical logic before moving on to more complex methods, Introduction to Biostatistical Applications in Health Research with Microsoft® Office Excel® also includes: Detailed discussions of how knowledge and skills in health research have been integrated with biostatistical methods Numerous examples with clear explanations that use mostly real-world health research data in order to provide a better understanding of the practical applications Implements Excel graphic representations throughout to help readers evaluate and analyze individual results An appendix with basic information on how to use Excel A companion website with additional Excel files, data sets, and homework problems as well as an Instructor’s Solutions Manual Introduction to Biostatistical Applications in Health Research with Microsoft® Office Excel® is an excellent textbook for upper-undergraduate and graduate-level courses in biostatistics and public health. In addition, the book is an appropriate reference for both health researchers and professionals.

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.

The must-have statistics guide for students of health services Statistics for Health Care Management and Administration is a unique and invaluable resource for students of health care administration and public health. The book introduces students to statistics within the context of health care, focusing on the major data and analysis techniques used in the field. All hands-on instruction makes use of Excel, the most common spreadsheet software that is ubiquitous in the workplace. This new third edition has been completely retooled, with new content on proportions, ANOVA, linear regression, chi-squares, and more, Step-by-step instructions in the latest version of Excel and numerous annotated screen shots make examples easy to follow and understand. Familiarity with statistical methods is essential for health services professionals and researchers, who must understand how to acquire, handle, and analyze data. This book not only helps students develop the necessary data analysis skills, but it also boosts familiarity with important software that employers will be looking for. Learn the basics of statistics in the context of Excel Understand how to acquire data and display it for analysis Master various tests including probability, regression, and more Turn test results into usable information with proper analysis Statistics for Health Care Management and Administration gets students off to a great start by introducing statistics in the workplace context from the very beginning.

As we move further into the 21st Century, sensory and consumer studies continue to develop, playing an important role in food science and industry. These studies are crucial for understanding the relation between food properties on one side and human liking and buying behaviour on the other. This book by a group of established scientists gives a comprehensive, up-to-date overview of the most common statistical methods for handling data from both trained sensory panels and consumer studies of food. It presents the topic in two distinct sections: problem-orientated (Part I) and method orientated (Part II), making it to appropriate for people at different levels with respect to their statistical skills. This book succesfully: Makes a clear distinction between studies using a trained sensory panel and studies using consumers. Concentrates on experimental studies with focus on how sensory assessors or consumers perceive and assess various product properties. Focuses on relationships between methods and techniques and on considering all of them as special cases of more general statistical methodologies It is assumed that the reader has a basic knowledge of statistics and the most important data collection methods within sensory and consumer science. This text is aimed at food scientists and food engineers working in research and industry, as well as food science students at master and PhD level. In addition, applied statisticians with special interest in food science will also find relevant information within the book.

This text is an accessible, student-friendly introduction to the wide range of mathematical and statistical tools needed by the forensic scientist in the analysis, interpretation and presentation of experimental measurements. From a basis of high school mathematics, the book develops essential quantitative analysis techniques within the context of a broad range of forensic applications. This clearly structured text focuses on developing core mathematical skills together with an understanding of the calculations associated with the analysis of experimental work, including an emphasis on the use of graphs and the evaluation of uncertainties. Through a broad study of probability and statistics, the reader is led ultimately to the use of Bayesian approaches to the evaluation of evidence within the court. In every section, forensic applications such as ballistics trajectories, post-mortem cooling, aspects of forensic pharmacokinetics, the matching of glass evidence, the formation of bloodstains and the interpretation of DNA profiles are discussed and examples of calculations are worked through. In every chapter there are numerous self-assessment problems to aid student learning. Its broad scope and forensically focused coverage make this book an essential text for students embarking on any degree course in forensic science or forensic analysis, as well as an invaluable reference for post-graduate students and forensic professionals. Key features: Offers a unique mix of mathematics and statistics topics, specifically tailored to a forensic science undergraduate degree. All topics illustrated with examples from the forensic science discipline. Written in an accessible, student-friendly way to engage interest and enhance learning and confidence. Assumes only a basic high-school level prior mathematical knowledge.

A thorough and definitive book that fully addresses traditional and modern-day topics of nonparametric statistics This book presents a practical approach to nonparametric statistical analysis and provides comprehensive coverage of both established and newly developed methods. With the use of MATLAB, the authors present information on theorems and rank tests in an applied fashion, with an emphasis on modern methods in regression and curve fitting, bootstrap confidence intervals, splines, wavelets, empirical likelihood, and goodness-of-fit testing. Nonparametric Statistics with Applications to Science and Engineering begins with succinct coverage of basic results for order statistics, methods of categorical data analysis, nonparametric regression, and curve fitting methods. The authors then focus on nonparametric procedures that are becoming more relevant to engineering researchers and practitioners. The important fundamental materials needed to effectively learn and apply the discussed methods are also provided throughout the book. Complete with exercise sets, chapter reviews, and a related Web site that features downloadable MATLAB applications, this book is an essential textbook for graduate courses in engineering and the physical sciences and also serves as a valuable reference for researchers who seek a more comprehensive understanding of modern nonparametric statistical methods.

Introducing the tools of statistics and probability from the ground up An understanding of statistical tools is essential for engineers and scientists who often need to deal with data analysis over the course of their work. Statistics and Probability with Applications for Engineers and Scientists walks readers through a wide range of popular statistical techniques, explaining step-by-step how to generate, analyze, and interpret data for diverse applications in engineering and the natural sciences. Unique among books of this kind, Statistics and Probability with Applications for Engineers and Scientists covers descriptive statistics first, then goes on to discuss the fundamentals of probability theory. Along with case studies, examples, and real-world data sets, the book incorporates clear instructions on how to use the statistical packages Minitab® and Microsoft® Office Excel® to analyze various data sets. The book also features: • Detailed discussions on sampling distributions, statistical estimation of population parameters, hypothesis testing, reliability theory, statistical quality control including Phase I and Phase II control charts, and process capability indices • A clear presentation of nonparametric methods and simple and multiple linear regression methods, as well as a brief discussion on logistic regression method • Comprehensive guidance on the design of experiments, including randomized block designs, one- and two-way layout designs, Latin square designs, random effects and mixed effects models, factorial and fractional factorial designs, and response surface methodology • A companion website containing data sets for Minitab and Microsoft Office Excel, as well as JMP ® routines and results Assuming no background in probability and statistics, Statistics and Probability with Applications for Engineers and Scientists features a unique, yet tried-and-true, approach that is ideal for all undergraduate students as well as statistical practitioners who analyze and illustrate real-world data in engineering and the natural sciences.