Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
Your form is submitting...
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
Email Address is required. 'Email Address' must contain at least 0 characters 'Email Address' cannot exceed 0 characters Please enter a valid Email Address
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Cengage, at your service! How can we best meet your needs? is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Modern Business Statistics with Microsoft®Office Excel® (with XLSTAT Education Edition Printed Access®Card), 6th Edition

David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran

  • Copyright 2018
  • {{checkPublicationMessage('Published', '2017-02-21T00:00:00+0000')}}
Starting At $77.95 See pricing and ISBN options
Instructor Next Steps
Students: Buy now
Modern Business Statistics with Microsoft®Office Excel® (with XLSTAT Education Edition Printed Access®Card) 6th Edition by David R. Anderson/Dennis J. Sweeney/Thomas A. Williams/Jeffrey D. Camm/James J. Cochran
Quick Navigation

Overview

Provide a balanced, conceptual understanding of statistics as MODERN BUSINESS STATISTICS, 6E focuses on real applications and Microsoft® Excel® 2016. This best-selling, comprehensive leader develops each statistical technique in an application setting with integrated Microsoft® Excel® 2016 instruction. Content focuses on statistical methodology as each presentation of a statistical procedure is followed by a discussion of how to use Excel® to perform the procedure. Step-by-step instructions and screen captures ensure understanding.

Business examples and application exercises demonstrate how statistical results provide insights into business decisions and problems. High-quality problems, noted for unwavering accuracy, and a signature problem-scenario approach apply statistical methods to business situations. New case problems and self-tests check reader understanding, while comprehensive support with MindTap and CengageNOW reinforce an understanding of business statistics.

{{readMore['overview'] ? 'Read More' : 'Read Less'}}

Meet the Authors

{{collapseContainerClosed['meet-the-author'] ? 'Show More' : 'Show Less'}}

David R. Anderson

David R. Anderson is a leading author and professor emeritus of quantitative analysis in the College of Business Administration at the University of Cincinnati. Dr. Anderson has served as head of the Department of Quantitative Analysis and Operations Management and as associate dean of the College of Business Administration. He was also coordinator of the college’s first executive program. In addition to introductory statistics for business students, Dr. Anderson taught graduate-level courses in regression analysis, multivariate analysis and management science. He also taught statistical courses at the Department of Labor in Washington, D.C. Dr. Anderson has received numerous honors for excellence in teaching and service to student organizations. He is the co-author of ten well-respected textbooks related to decision sciences and he actively consults with businesses in the areas of sampling and statistical methods. Born in Grand Forks, North Dakota, Dr. Anderson earned his B.S., M.S. and Ph.D. degrees from Purdue University.

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 B.S.B.A. degree from Drake University and his M.B.A. and D.B.A. degrees from Indiana University, where he was an NDEA fellow. Dr. Sweeney has worked in the management science group at Procter & Gamble and has been a visiting professor at Duke University. He also served as head of the Department of Quantitative Analysis and served four years as associate dean of the College of Business Administration at the University of Cincinnati. Dr. 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 journals such as Management Science, Operations Research, Mathematical Programming and Decision Sciences. Dr. Sweeney has co-authored 10 textbooks in the areas of statistics, management science, linear programming and production and operations management.

Thomas A. Williams

N/A

Jeffrey D. Camm

Jeffrey D. Camm is the Inmar Presidential Chair of Analytics and Senior Associate Dean for Faculty in the School of Business at Wake Forest University. Born in Cincinnati, Ohio, he holds a B.S. from Xavier University (Ohio) and a Ph.D. from Clemson University. Prior to joining the faculty at Wake Forest, Dr. Camm served on the faculty of the University of Cincinnati. He has also been a visiting scholar at Stanford University and a visiting professor of business administration at the Tuck School of Business at Dartmouth College. Dr. Camm has published more than 45 papers in the general area of optimization applied to problems in operations management and marketing. He has published his research in Science, Management Science, Operations Research, The INFORMS Journal on Applied Analytics and other professional journals. Dr. Camm was named the Dornoff Fellow of Teaching Excellence at the University of Cincinnati and he was the recipient of the 2006 INFORMS Prize for the Teaching of Operations Research Practice. A firm believer in practicing what he preaches, he has served as a consultant to numerous companies and government agencies. Dr. Camm served as editor-in-chief of INFORMS Journal on Applied Analytics and is an INFORMS fellow.

James J. Cochran

James J. Cochran is Professor of Applied Statistics, the Mike and Cathy Mouron Research Chair and Associate Dean for Faculty and Research at the University of Alabama. Born in Dayton, Ohio, he earned his B.S., M.S. and M.B.A. degrees from Wright State University and his Ph.D. from the University of Cincinnati. Dr. Cochran has served at The University of Alabama since 2014 and has been a visiting scholar at Stanford University, Universidad de Talca, the University of South Africa and Pole Universitaire Leonard de Vinci. Dr. Cochran has published more than 50 papers in the development and application of operations research and statistical methods. He has published his research in Management Science, The American Statistician, Communications in Statistics-Theory and Methods, Annals of Operations Research, European Journal of Operational Research, Journal of Combinatorial Optimization, INFORMS Journal on Applied Analytics, BMJ Global Health and Statistics and Probability Letters. He was the 2008 recipient of the INFORMS Prize for the Teaching of Operations Research Practice and the 2010 recipient of the Mu Sigma Rho Statistical Education Award. He received the Founders Award in 2014 and the Karl E. Peace Award in 2015 from the American Statistical Association. In 2017 he received the American Statistical Association’s Waller Distinguished Teaching Career Award and in 2018 he received the INFORMS President’s Award. Dr. Cochran is an elected member of the International Statistics Institute, a fellow of the American Statistical Association and a fellow of INFORMS. A strong advocate for effective statistics and operations research education as a means of improving the quality of applications to real problems, Dr. Cochran has organized and chaired teaching workshops throughout the world.

What's New

{{collapseContainerClosed['whats-new'] ? 'Show More' : 'Show Less'}}
  • NEW, ADDITIONAL CASE PROBLEMS PROVIDE MORE PRACTICE ANALYZING AND PREPARING REPORTS. This edition includes 11 new case problems to challenge your students. The 30 case problems in the text provide students with the opportunity to analyze somewhat larger data sets and to prepare managerial reports based on the results of their analyses.
  • UPDATED AND IMPROVED END-OF-CHAPTER SOLUTIONS AND SOLUTIONS MANUAL ENSURE ACCURATE, TRUSTED ANSWERS. The authors have carefully reviewed and reworked, when needed, every question and solution in this edition's end-of chapter solutions and solutions manual. The solutions now boast higher accuracy and contain additional details to assist in efficient grading. You'll find improved rounding instructions, expanded explanations with a student-focus, and alternative answers using Excel and a statistical calculator.

Features

{{collapseContainerClosed['features'] ? 'Show More' : 'Show Less'}}
  • INTEGRATED MICROSOFT® EXCEL® 2016 FEATURES STEP-BY-STEP INSTRUCTIONS AND SCREEN CAPTURES. These visuals and instructions clearly demonstrate how to use the latest version of Excel® to implement statistical procedures. Students learn how Excel's new recommended PivotTables tool and new Recommended Chart tool are extremely useful in developing tabular and graphical displays.
  • NEW EXCEL® 2016 PRIMER ADDRESSES BASIC OPERATIONS FOR STUDENTS WHO NEED REVIEW OR ADDITIONAL INSTRUCTION. This new section of material -- "Microsoft Excel 2016 Tools for Statistical Analysis" -- appears as an appendix at the end of the book. Content emphasizes basic Excel® operations and discusses how to open and save workbooks, copy and paste, and enter formulas.
  • REVISED CONTENT IN CHAPTER 1 CLEARLY INTRODUCES ANALYTICS. A new section on analytics describes what analytics is, the types of analytics used in business today and how this relates to statistics. An expanded section on data mining in this initial chapter includes a discussion of big data and how businesses use data mining for competitive advantage.
  • REVISED, CLEAR COVERAGE EMPHASIZES HOW TO USE BOXPLOTS WITHIN EXCEL 2016. Chapter 3 offers new, additional coverage that details how to use Excel 2016 to create boxplots and comparative boxplots.
  • NEW SECTION HIGHLIGHTS THE PRACTICAL IMPLICATIONS OF BIG DATA ON SAMPLING ERROR. This new content in Chapter 7 now discusses big data in detail.
  • ADDITIONAL CONTENT NOW EMPHASIZES THE PRACTICAL IMPLICATIONS OF BIG DATA ON CONFIDENCE INTERVALS. New insights and coverage in this edition's revised Chapter 8 highlight how today's big data impacts confidence intervals.
  • NEW CONTENT NOW DETAILS THE PRACTICAL IMPLICATIONS OF BIG DATA ON HYPOTHESIS TESTING. The authors have added coverage within this edition's revised Chapter 9 that emphasizes how use of big data can impact hypothesis testing.
  • MINDTAP® COMPLETE DIGITAL SOLUTION NOW FEATURES ALL-NEW EXCEL ONLINE INTEGRATION POWERED BY MICROSOFT®. Ideal for your business statistics course, MindTap® takes students from learning basic statistical concepts to actively engaging in critical thinking applications, while learning valuable software skills for their future careers. MindTap® is a customizable digital course solution that includes an interactive eBook and auto-graded, algorithmic exercises from the textbook. All of these materials offer students better access that enable them to truly master the materials in your course.
  • CENGAGENOW™ FULLY INTEGRATED ONLINE TEACHING AND LEARNING SYSTEM SAVES TIME WHILE ENSURING STUDENT MASTERY. 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. You 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 MAKE CONCEPTS REAL AND MEMORABLE FOR STUDENTS. A well-known strength of this author team, exceptional exercises and examples throughout this edition are strengthened with more real data from sources such as the Census Bureau and the Wall Street Journal. Exercises drawn from real events encourage students to learn the statistical methodology and apply real data to problems. Approximately 140 new examples and exercises have been added to the book's more than 980 exercises.
  • PROVEN SELF-TEST EXERCISES 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 IMMEDIATELY EMPHASIZE THE PRACTICAL VALUE OF THE INFORMATION STUDENTS ARE LEARNING. Statistics in Practice chapter openers highlight intriguing scenarios from companies such as Citibank and Procter & Gamble and clearly demonstrate the value of statistics in everyday business situations. These high-interest openers draw students into the chapter information that follows.
  • AUTHORS EQUALLY EMPHASIZE METHODS AND APPLICATIONS. This experienced author team strikes an appropriate balance as Methods Exercises at the end of each section require students to use formulas and make necessary computations. In addition, practical Application Exercises ask students to apply the chapter material to address real-world problems.
  • TRUSTED TEAM OF EXPERT AUTHORS ENSURE A QUALITY, PRACTICALLY FOCUSED PRESENTATION. As respected leaders and active consultants in the fields of business and statistics, Anderson, Sweeney, Williams, Camm and Cochran provide an accurate presentation of statistical concepts you can trust with every edition. They use their teaching experience to provide a cohesive, student-friendly writing approach. To ensure accuracy, the authors triple-check all problems and examples themselves.

Table of Contents

{{collapseContainerClosed['table-of-contents'] ? 'Show More' : 'Show Less'}}
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 (online).
21. Sample Survey (online).
Appendix A: References and Bibliography.
Appendix B: Tables.
Appendix C: Summation Notation.
Appendix D: Self-Test Solutions and Answers to Even-Numbered Exercises (online).
Appendix E: Microsoft Excel 2016 and Tools for Statistical Analysis.

Compare Buying Options

{{collapseContainerClosed['compare-buying-options'] ? 'Show More' : 'Show Less'}}

MindTap Options

{{collapseContainerClosed['detail_1'] ? 'Show More' : 'Show Less'}}
MindTap
Each MindTap product offers the full, mobile-ready textbook combined with superior and proven learning tools at one affordable price. Students who purchase digital access can add a print option at any time when a print option is available for their course.

This Cengage solution can be seamlessly integrated into most Learning Management Systems (Blackboard, Brightspace by D2L, Canvas, Moodle, and more) but does require a different ISBN for access codes. Please work with your Cengage Learning Consultant to ensure the proper course set up and ordering information. For additional information, please visit the LMS Integration site.

Standalone Digital Access — Ultimate Value

Recommended and most popular

  • ISBN-10: 0357110625
  • ISBN-13: 9780357110621
  • RETAIL $99.95

  • ISBN-10: 0357110595
  • ISBN-13: 9780357110591
  • RETAIL $99.95
Instructor Next Steps
Students: Buy now

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}

  • ISBN-10: 0357685652
  • ISBN-13: 9780357685655
  • RETAIL $77.95
Instructor Next Steps
Students: Buy now

Supplements

{{collapseContainerClosed['supplements'] ? 'Show More' : 'Show Less'}}

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR STUDENTS

MindTapV2.0 for Anderson/Sweeney/Williams/Camm/Cochran's Modern Business Statistics with Microsoft Excel, 1 term Instant Access

ISBN: 9780357110621
MindTap V2.0 Business Statistics, for Anderson/Sweeney/Williams/Camm/Cochran's Modern Business Statistics with Microsoft Excel is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course--to provide engaging content, to challenge every individual and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap, featuring all new Excel Online integration powered by Microsoft, is a complete digital solution for the business statistics course. It has enhancements that take students from learning basic statistical concepts to actively engaging in critical thinking applications, while learning valuable software skills for their future careers. MindTap now includes enhanced mastery problem sets powered by Aplia. Aplia, the best-selling online homework solution, offers a more accessible, optimized mobile experience, allowing students to access content on their mobile devices anywhere. These problem sets deepen conceptual understanding by including interactive distribution and dataview tools with elements that require analysis and interpretation. Aplia provides instant feedback and explanations -- so students master the material. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics and add your own material or notes in the ebook.

MindTapV2.0 for Anderson/Sweeney/Williams/Camm/Cochran's Modern Business Statistics with Microsoft Excel, 2 terms Instant Access

ISBN: 9780357110591
MindTap V2.0 Business Statistics, for Anderson/Sweeney/Williams/Camm/Cochran's Modern Business Statistics with Microsoft Excel is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course--to provide engaging content, to challenge every individual and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics and add your own material or notes in the ebook.