Nelson Higher Education

Higher Education

Essentials of Modern Business Statistics with Microsoft® Excel®, 6th Edition

  • David R. Anderson
  • Dennis J. Sweeney
  • Thomas A. Williams
  • ISBN-10: 1285867041
  • ISBN-13: 9781285867045
  • 784 Pages | Hardcover
  • Previous Editions: 2012, 2009, 2007
  • COPYRIGHT: 2016 Published
Request a Copy for Review

Overview

About the Product

Integrating Microsoft Excel® 2013 throughout, ESSENTIALS OF MODERN BUSINESS STATISTICS, 6TH EDITION provides an introduction to business statistics that blends a conceptual understanding of statistics with the real-world application of statistical methodology. Leading the business statistics market for two decades, this author team is renowned for their high-quality problems, unwavering accuracy, and signature problem-scenario approach that clearly illustrates how to apply statistical methods in practical business situations. Step-by-step instructions and screen captures show students how to most effectively use the latest version of Excel in statistical procedures, while numerous exercises give them hands-on experience putting what they learn into practice. In addition, the Sixth Edition is packed with all-new Case Problems, Statistics in Practice applications, and real data examples and exercises.

Features

  • INTEGRATION OF EXCEL. Immediately following every statistical procedure, a sub-section discusses how to use Excel to perform that procedure. This style enables the use of Excel to be integrated throughout the text while keeping the primary emphasis on the statistical methodology being discussed. In addition, each sub-section uses a consistent framework for applying Excel to help users focus on the statistical methodology without getting bogged down in the details of using Excel.

  • PROBLEM-SCENARIO APPROACH. With its hands-on approach, the text presents discussion and development of each technique in an applications setting, with the statistical results providing insights to decisions and solutions to problems. The problem scenarios enable students to see how statistics can be applied in real-world business and economics practice--increasing their interest and motivation for learning statistics.

  • STUDENT READABILITY. For more than 30 years, student surveys and instructor feedback have shown that readability is a hallmark of ASW textbooks. In addition, the text is packed with real-world examples, current illustrations, and step-by-step instructions.

  • OUTSTANDING EXERCISES. End-of-section exercises are split into two parts: Methods and Applications. The Methods exercises require students to use formulas and make appropriate computations. The Applications exercises require students to use the chapter material in real-world situations. Many of the Applications exercises are based on recent data obtained from referenced sources. Combining these two methods enables students to focus on the computational "nuts and bolts" before advancing to the subtleties of statistical application and interpretation. Certain exercises are identified as self-test exercises and have completely worked-out-solutions provided in Appendix D.

  • DATA FILES. Data files for case problems and for exercises with large amounts of data are available on the student companion website. These are in Excel 2013, and will save students time and reduce the likelihood of errors in data entry. The WEBfile logo in the margin indicates the existence of a data file; the name of the file appears under the logo.

  • MARGIN ANNOTATIONS AND NOTES AND COMMENTS. Helping ensure thorough student understanding, margin annotations highlight key points and provide additional insights. Many sections end with Notes and Comments designed to give students additional insights about the statistical methodology and its application. Notes and Comments include warnings about or limitations of the methodology, recommendations for application, brief descriptions of additional technical considerations, and more.

  • FREE ACCESS TO STATTOOLS FROM PALISADE CORPORATION. StatTools is an industry-standard Excel add-in that is available to adopters of this text at no charge. StatTools extends the range of statistical and graphical options for Excel users. Its use is completely optional. Instructions for downloading and installing StatTools are in an appendix to Chapter 1, and most chapters include an appendix that shows the steps required to accomplish a statistical procedure using StatTools.

  • SELF-TEST EXERCISES. Helping students maximize their course success, step-by-step solutions for self-test exercises are provided in Appendix D. Students can attempt the Self-Test exercises and immediately check the solution to evaluate their understanding of the concepts presented in each chapter.

About the Author

David R. Anderson

Dr. David R. Anderson is a leading author and Professor Emeritus of Quantitative Analysis in the College of Business Administration at the University of Cincinnati. He 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 has taught graduate-level courses in regression analysis, multivariate analysis, and management science. He also has 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 actively consults with businesses in the areas of sampling and statistical methods. Born in Grand Forks, North Dakota, he 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 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

Table of Contents

1. Data and Statistics.
2. Descriptive Statistics: Tabular and Graphical Presentations.
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. Comparisons Involving Means, Experimental Design, and Analysis of Variance.
11. Comparisons Involving Proportions and a Test of Independence.
12. Simple Linear Regression.
13. Multiple Regression.
14. Timer Series Analysis and Forecasting (on Website).
15. Statistical Methods for Quality Control (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 2013 to implement statistical procedures. Excel's new Recommended PivotTables tool and Excel's new Recommended Chart tool are very useful in developing tabular and graphical displays. In addition, the new Appendix E provides a thorough introduction to Excel 2013 and tools for statistical analysis.
  • NEW ILLUSTRATIONS. Chapter 2 "Descriptive Statistics: Tabular and Graphical Presentations" now includes illustrations of new tools available with Excel 2013 and new material on data visualization. The illustrations demonstrate how Excel's new Recommended PivotTables tool is used to construct frequency distributions and how Excel's Recommended Charts tool is used to construct side-by-side and stacked bar charts.
  • EXPANDED WEIGHTED MEAN AND GEOMETRIC MEAN COVERAGE. Chapter 3 "Descriptive Statistics: Numerical Measures" 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, annual percentage rates, etc. 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 and explains how summary statistics can be incorporated to enhance their effectiveness.
  • REVAMPED COVERAGE OF PROBABILITIES. The introductory material in Chapter 5 "Discrete Probability Distributions" has been revised to show how the material on assigning probabilities in Chapter 4 "Introduction to Probability" can be used to develop discrete probability distributions. The empirical discrete probability distribution is developed by using the relative frequency method to assign probabilities.
  • REVISED COMPARISONS COVERAGE. Chapter 11 "Comparisons Involving Proportions and a Test of Independence" has been thoroughly reorganized. While it continues to cover inferences about two population proportions, the chapter also extends the material to hypothesis tests concerning three or more population proportions. The chapter concludes with the Test of Independence.

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

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1285868951 | ISBN-13: 9781285868950)

Cengage Learning Testing Powered by Cognero is a flexible, online system that allows you to author, edit, and manage test bank content, create multiple test versions in an instant, and deliver tests from your LMS, in your classroom or through CengageNOW.

Solutions Manual  (ISBN-10: 1305251105 | ISBN-13: 9781305251106)

At the request of the instructor, a print version of the Solutions Manual can be packaged with the text for student purchase.

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

MindTap is a highly personalized, fully online learning platform of authoritative Cengage Learning content, assignments, and services--offering you a tailored presentation of course curriculum created by your instructor. MindTap guides you through the course via an innovative learning path, where you will complete reading assignments in the MindTap Reader, annotate your readings, complete homework, and engage with quizzes and assessments. To enhance your learning experience, MindTap includes a variety of web apps known as MindApps, which allow you to have the text read aloud to you, synchronize your notes with your personal EverNote account, and more.

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

CENGAGENOW ONLINE COURSE MANAGEMENT SYSTEM HELPS YOU IMPROVE STUDENT RESULTS NOW! This robust, online course management system gives you more control in less time and provides student with the resources they need -- NOW. CengageNOW includes teaching and learning resources organized around lecturing, creating assignments, grading, quizzing, and tracking student progress and performance. Flexible assignment settings, automatic grading and gradebook options provide more control while saving you valuable time. A Personalized Study diagnostic tool empowers students to master concepts, prepare for exams, and become more involved in class. Visit www.cengage.com/discoverdigital to see how CengageNOW can help you easily set your own course, elevate thinking in your course, and improve student outcomes.

Student Supplements

Solutions Manual  (ISBN-10: 1305251105 | ISBN-13: 9781305251106)

At the request of the instructor, a print version of the Solutions Manual can be packaged with the text for student purchase.

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

MindTap Business Statistics for Anderson/Sweeney/Williams' Essentials of Modern Business Statistics with Microsoft® Excel®, 6th Edition provides you with the tools you need to better manage your limited time -- you can complete assignments whenever and wherever you are ready to learn with course material specially customized for you by your instructor and streamlined in one proven, easy-to-use interface. MindTap Business Statistics includes videos that highlight the content's relevance, meaningful animated examples and practice opportunities, and simulations to teach you to interpret data to make informed business decisions. MindTap ultimately gives you a roadmap to successfully master decision making in business statistics. With these resources and an array of tools and apps -- from note taking to flashcards -- you'll get a true understanding of course concepts, helping you to achieve better grades and setting the groundwork for your future courses. Access to this product is valid for 6 months of usage.

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

CengageNOW provides you with the resources you need to be more successful -- NOW. CengageNOW includes learning resources organized around the way you learn to help you be more efficient and effective in your studies. A Personalized Study diagnostic tool empowers you to master concepts, prepare for exams, and become more involved in class.