Product Description

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.

Product Details

• Amazon Sales Rank: #371932 in Books
• Published on: 2008-06-20
• Original language: English
• Number of items: 1
• Binding: Paperback
• 288 pages

From the Back Cover
This book provides a complete introduction to statistics using Excel. Its easy-to-understand basic spreadsheet operations, and its Analysis Tools make Excel an superb software package to carry out statistical analyses. Covers Excel's numerous options for constructing charts, manipulating and transforming data, and pasting output into written documents. Excel's Analysis Tools provide numerous statistical analysis procedures: descriptive statistics, correlation, regression, t-test, and two-way analysis of variance.

About the Author

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.

Customer Reviews

Buy only if you already know statistics
I had hoped this book would explain the statistical techniques themselves before jumping into how to use Excel, which is all it really does. If you already know statistics (which I did not) and don't know Excel (which I did) this will help. If the reverse is true, keep looking.

First-class piece of work.
From a reviewer: I teach mathematics/statistics in the Education dept at Liverpool John Moores University, England. I have been asked by the publication 'Teaching Statistics' to review your recent book on Statistics with Excel.

I would like to congratulate you on this first class piece of work. I have felt for some time that the profession is too hung up with the usefulness of dedicated stats packages. Too often I believe, statistics departments believe that the costlier the package, then the better it is. Untrue!

Keeping it Simple
The layout of the book is simple, straightforward, and easy to follow. The editors included lots of "white space" which a book of this nature requires ... it keeps you from feeling overwhelmed. The interactive nature of the exercises and the explanations and diagrams are nicely organized. The book itself is very light and easy to carry around. Overall, I found it to be very accessible, and I would recommend it to others as a great resource.