Statistics with Microsoft Excel

Statistics with Microsoft Excel, Fifth Edition, shows readers how to use Microsoft Excel^® to perform statistical analysis. This step-by-step guide has been updated to cover the new features and interface of Excel 2010.

Datasets and other resources (where applicable) for this book are available here.

Key Message: Statistics with Microsoft Excel^®, Fourth Edition shows readers how to use Microsoft Excel^® to perform statistical analysis. This step-by-step guide has been updated to cover the new features and new interface of Excel 2007.

Key Topics: Getting Started; Entering, Editing, and Recoding Information; Formulas; Frequency Distributions; Descriptive Statistics; Probability Distributions; Testing Hypotheses About One Sample Means; Testing Hypotheses About the Difference Between Two Means; Analysis of Variance; Correlation; Regression; Cross Tabulations; Random Samples

MARKET:For a variety of disciplines, including mathematics, the social sciences, and business. This book will be useful for data analysts and all readers who wish to use Excel to record, manipulate, and analyze their data.

Beverly J. Dretzke, PhD, is a research associate at the University of Minnesota’s Center for Applied Research and Educational Improvement (CAREI). She serves as a principal investigator and project manager for projects related to program evaluation in school districts throughout Minnesota. Evaluation projects that she has worked on include studies of teacher professional development, Chinese language programs, and small learning communities. Prior to joining the staff at CAREI, Dretzke was a professor of psychology at the University of Wisconsin-Eau Claire where she taught courses in statistics, measurement, and educational psychology. She received her doctorate in educational psychology from the University of Wisconsin—Madison.