# Modern Business Statistics with Microsoft® Excel®, 5th Edition

• David R. Anderson
• Dennis J. Sweeney
• Thomas A. Williams
• ISBN-10: 1285433300
• ISBN-13: 9781285433301
• 1056 Pages | Hardcover
• Previous Editions: 2012, 2009, 2006
• COPYRIGHT: 2015 Published
Request a Copy for Review

# Overview

## Features

• Revised Chapter 5: The introductory material has been revised to show how the material on assigning probabilities in Chapter 4 can be used to develop discrete probability distributions. The empirical discrete probability distribution is developed using the relative frequency method to assign probabilities. At the request of many users, Anderson, Sweeney, and Williams have added a new section (Section 5.4) that covers bivariate discrete distributions and financial applications such as portfolio development.

• Chapter 12: Sections 12.1 and 12.2 have been rewritten to better explain how the goodness of fit test and the test of independence are related methods for the analysis of categorical data. Section 12.3 (Testing for Equality of Three or More Population Proportions) is a new section that shows how methods for categorical data analysis can be used in tests for multiple proportions. For the hypothesis tests in each section, Excel's CHISQ.TEST function is used to compute the p-value corresponding to the chi-square test statistic.

• CengageNOW Fully Integrated Online Teaching and Learning System: This innovative course management system combines the best of current technology to help you plan your course, manage and automatically grade extensive homework and student assignments, teach with the latest built-in technology support, and test students using a customized test bank. Personalized study plans for each student help reinforce student comprehension and reduce questions.

• Powerful Examples and Exercises: Always a well-known strength from this author team, the exceptional exercises and examples throughout this text are stronger with more real data from sources such as the Census Bureau and the Wall Street Journal. Exercises drawn from real-world events encourage students to learn the statistical methodology and the application of real data to problems. Nine new cases and approximately 225 new examples and exercises have been added to the core material. There are 983 exercises in MODERN BUSINESS STATISTICS WITH MICROSOFT® EXCEL®, 5E.

• Proven Self-Test Exercises to Ensure Student Understanding: Completely worked-out solutions for specific exercises appear in an appendix at the end of the book. Students can complete the self-test exercises and immediately check their solutions to evaluate their understanding of the concepts presented in the chapter.

• Statistics in Practice Chapter Openers: Students immediately see the practical value of the information they are learning as Statistics in Practice chapter openers highlight intriguing scenarios from companies such as Citibank and Procter & Gamble using statistics in everyday business situations. These high-interest openers draw students into the information that follows. New to this edition is a Statistics in Practice for Chapter 2, describing the use of data dashboards and data visualization at the Cincinnati Zoo. A new Statistics in Practice has also been added to Chapter 4, describing how a NASA team used probability to assist the rescue of 33 Chilean miners trapped by a cave-in.

• Equal Emphasis on Methods and Applications: Methods Exercises at the end of each section require students to use formulas and make necessary computations, whereas Application Exercises ask students to apply the chapter material to address real-world problems.

• Trusted Team of Expert Authors: As respected leaders and active consultants in the fields of business and statistics, Anderson, Sweeney, and Williams provide an accurate presentation of statistical concepts you can trust with every edition as they use a cohesive, student-friendly writing approach. To ensure accuracy, the authors triple-check all problems and examples themselves.

## About the Author

David R. Anderson

Dennis J. Sweeney

Dennis J. Sweeney is Professor Emeritus of Quantitative Analysis and founder of the Center for Productivity Improvement at the University of Cincinnati. Born in Des Moines, Iowa, he earned a BSBA degree from Drake University and his MBA and DBA degrees from Indiana University, where he was an NDEA Fellow. Professor Sweeney has worked in the management science group at Procter & Gamble and has been a visiting professor at Duke University. Professor Sweeney served as Head of the Department of Quantitative Analysis and four years as Associate Dean of the College of Business Administration at the University of Cincinnati. Professor Sweeney has published more than 30 articles and monographs in the area of management science and statistics. The National Science Foundation, IBM, Procter & Gamble, Federated Department Stores, Kroger and Cincinnati Gas & Electric have funded his research, which has been published in Management Science, Operations Research, Mathematical Programming, Decision Sciences and other journals. Professor Sweeney has co-authored ten textbooks in the areas of statistics, management science, linear programming and production and operations management.

Thomas A. Williams

N/A

1. Data and Statistics.
2. Descriptive Statistics: Tabular and Graphical Displays.
3. Descriptive Statistics: Numerical Measures.
4. Introduction to Probability.
5. Discrete Probability Distributions.
6. Continuous Probability Distributions.
7. Sampling and Sampling Distributions.
8. Interval Estimation.
9. Hypothesis Tests.
10. Statistical Inferences About Means and Proportions with Two Populations.
11. Inferences About Population Variances.
12. Comparing Multiple Proportions, Test of Independence and Goodness of Fit.
13. Experimental Design and Analysis of Variance.
14. Simple Linear Regression.
15. Multiple Regression.
16. Regression Analysis: Model Building.
17. Time Series Analysis and Forecasting.
18. Nonparametric Methods.
19. Statistical Methods for Quality Control.
20. Decision Analysis on Website.
21. Sample Survey on Website.
Appendix A: References and Bibliography.
Appendix B: Tables.
Appendix C: Summation Notation.
Appendix D: Self-Test Solutions and Answers to Even-Numbered Exercises.
Appendix E: Microsoft Excel 2013 and Tools for Statistical Analysis.

# New to this edition

• Integrated Microsoft® Excel® 2013: Step-by-step instructions and screen captures clearly demonstrate how to use the latest version of Excel® to implement statistical procedures. Excel's new recommended PivotTables tool and new Recommended Chart tool are very useful in developing tabular and graphical displays.
• Excel® 2013 Primer: "Microsoft Excel 2013 Tools for Statistical Analysis." This new section of material on basic Excel® operations discusses how to open and save workbooks, copy and paste, and enter formulas. It appears as an appendix at the end of the book.
• Microsoft® Excel® Add-ins Optional Appendices: New chapter appendices give you the choice of covering StatTools, an industry-standard add-in that students will use throughout their business careers. Appendices highlight how this Microsoft® Excel® add-in provides capabilities not available in Excel® 2010, such as producing a box plot. This optional coverage allows you to choose to present Excel® with or without StatTools.
• Revised Chapter 2: Chapter 2 now includes illustrations of new tools available with Excel® 2013 and new material on data visualization. Excel's new Recommended PivotTables tool is used to construct frequency distributions for categorical variables, and Excel's Recommended Charts tool is used to construct side-by-side and stacked bar charts.
• Revised Chapter 3: Chapter 3 now includes coverage of the weighted mean and geometric mean in the section on measures of location. The geometric mean has many financial applications in the computation of asset growth rates and annual percentage rates, for example. Anderson, Sweeney, and Williams have revised their procedure for computing percentiles and quartiles to be consistent with Excel's new PERCENTILE.EXC function. Chapter 3 also includes a new section on data dashboards, discussing how summary statistics can be incorporated to enhance their effectiveness.

# Supplements

All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

## Instructor Supplements

Website  (ISBN-10: 1285839587 | ISBN-13: 9781285839585)

Everything you need for your course is in one place! This collection of book-specific lecture and class tools is available online via www.cengage.com/login. Access and download PowerPoint® presentations, images, the Instructor's Manual, videos, and more.

Solutions Manual  (ISBN-10: 1285842219 | ISBN-13: 9781285842219)

Prepared by the text's author team to ensure unwavering excellence, this Solutions Manual includes solutions for all problems in the text.

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1285978714 | ISBN-13: 9781285978710)
CengageNOW, 1 term (6 months) Instant Access  (ISBN-10: 1305263235 | ISBN-13: 9781305263239)

With its engaging learning and assessment tools, CengageNOW supports the entire student workflow, from motivation to mastery. For instructors, CengageNOW provides control and customization with the opportunity to tailor the learning experience to improve outcomes.

CengageNOW, 2 terms (12 months) Instant Access  (ISBN-10: 1285433815 | ISBN-13: 9781285433813)

Bring a new level of ease in preparation and student understanding to your course with CengageNOW. This innovative, integrated online course management and student learning system combines the best of current technology to save you time in planning your course and student assignments, help you teach with the latest built-in course support materials, reinforce comprehension with customized student learning paths, efficiently test student knowledge, and automatically grade assignments and tests. Take full advantage of this time-saving, effective resource with Cengage Learning's specialized training and service program for CengageNOW. For more information, visit academic.cengage.com/cengagenow.

MindTap Business Statistics, 1 term (6 months) Instant Access for Anderson/Sweeney/Williams' Modern Business Statistics with Microsoft® Excel®  (ISBN-10: 1305579704 | ISBN-13: 9781305579705)

MindTap Business Statistics, 2 terms (12 months) Instant Access for Anderson/Sweeney/Williams' Modern Business Statistics with Microsoft® Excel®  (ISBN-10: 1285839706 | ISBN-13: 9781285839707)

MindTap is a fully online, highly personalized learning experience built on Cengage Learning content. MindTap combines student learning tools--readings, multimedia, activities, and assessments--in a singular Learning Path that guides students through the course. You personalize the experience by customizing authoritative Cengage Learning content and learning tools, including the ability to add your own content in the Learning Path via apps that seamlessly integrate with the MindTap framework with Learning Management Systems.

EasyStat Digital Tutor, 2 terms (12 months) Instant Access  (ISBN-10: 1305105540 | ISBN-13: 9781305105546)
LMS Integrated for CengageNOW, 1 term Instant Access  (ISBN-10: 1305255070 | ISBN-13: 9781305255074)

With its engaging learning and assessment tools, CengageNOW supports the entire student workflow, from motivation to mastery. For instructors, CengageNOW provides control and customization with the opportunity to tailor the learning experience to improve outcomes.

LMS Integrated for CengageNOW, 2 terms Instant Access  (ISBN-10: 1305255054 | ISBN-13: 9781305255050)

With its engaging learning and assessment tools, CengageNOW supports the entire student workflow, from motivation to mastery. For instructors, CengageNOW provides control and customization with the opportunity to tailor the learning experience to improve outcomes.

LMS Integrated for Aplia, 1 term Instant Access  (ISBN-10: 1305255119 | ISBN-13: 9781305255111)

Aplia significantly improves outcomes and elevates thinking by increasing student effort and engagement. Developed by teachers and used by more than 1,000,000 students Aplia assignments connect concepts to the real world and focus on the unique course challenges facing students.

LMS Integrated for MindTap Business Statistics, 2 terms (12 months) Instant Access  (ISBN-10: 1305255011 | ISBN-13: 9781305255012)

This access code will provide your students with seamless access to their MindTap Business Statistics resources from within your campus Learning Management System. Students will be prompted to enter this access code the first time that they click on a link in your course that includes Cengage content.

LMS Integrated for MindTap Business Statistics, 1 term (6 months) Instant Access  (ISBN-10: 1305255038 | ISBN-13: 9781305255036)

This access code will provide your students with seamless access to their MindTap Business Statistics resources from within your campus Learning Management System. Students will be prompted to enter this access code the first time that they click on a link in your course that includes Cengage content.

## Student Supplements

CengageNOW, 1 term (6 months) Instant Access  (ISBN-10: 1305263235 | ISBN-13: 9781305263239)

CengageNOW, 2 terms (12 months) Instant Access  (ISBN-10: 1285433815 | ISBN-13: 9781285433813)

CengageNOW is an easy-to-use online student learning system that combines the best of current technology to help you study in less time and get the grade you want.

MindTap Business Statistics, 1 term (6 months) Instant Access for Anderson/Sweeney/Williams' Modern Business Statistics with Microsoft® Excel®  (ISBN-10: 1305579704 | ISBN-13: 9781305579705)

MindTap Business Statistics, 2 terms (12 months) Instant Access for Anderson/Sweeney/Williams' Modern Business Statistics with Microsoft® Excel®  (ISBN-10: 1285839706 | ISBN-13: 9781285839707)

EasyStat Digital Tutor, 2 terms (12 months) Instant Access  (ISBN-10: 1305105540 | ISBN-13: 9781305105546)
LMS Integrated for CengageNOW, 1 term Instant Access  (ISBN-10: 1305255070 | ISBN-13: 9781305255074)

LMS Integrated for CengageNOW, 2 terms Instant Access  (ISBN-10: 1305255054 | ISBN-13: 9781305255050)