Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.

Gerald Keller's new APPLIED STATISTICS WITH MICROSOFT® EXCEL integrates Excel into the general introductory statistics course. Keller, the co-author of the market-leading STATISTICS FOR MANAGEMENT AND ECONOMICS, Fifth Edition, incorporates his proven three-step problem-solving process throughout this book. The first step, "Identify," is the work a statistician does before the calculations are performed, which entails organizing the experiment, gathering the data, and deciding which statistical techniques to employ. The second step, "Compute," is the computation with Excel. In this step, Keller shows the manual calculation for the simplest of techniques only. For example, he describes how to calculate the sample mean, variance, and standard deviation, how to compute the z-interval estimate of, and the z-test of. The third step, "Interpret," is the interpretation of the computer output, which requires an understanding of statistical concepts.

Provides students with additional help and information for learning key concepts in applied statistics.

Contains worked-out solutions to all exercises.