Nelson Higher Education

Higher Education

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

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

Overview

About the Product

ESSENTIALS OF MODERN BUSINESS STATISTICS, 5TH EDITION provides an introduction to business statistics that blends a conceptual understanding of statistics with the real-world application of statistical methodology. Microsoft Excel® 2010 is integrated throughout the text, showing step-by-step instructions and screen captures to enhance student learning. The fifth edition contains the same student learning features that have made ASW products best-sellers for years, including the problem-scenario approach and real-world examples that introduce statistical techniques. A student companion site comes includes: Case Files, Example Files, Problem Files, Tutorials, Solvertable, Palisade DecisionTools (StatTools), Excel Tutorial.

Features

  • Included with the purchase of the new book is the Student Complimentary Site that gives access to WEBfiles and Palisade Decision Tools (Stat Tools).

  • PROBLEM-SCENARIO APPROACH. Using this approach, the discussion and development of each technique is presented 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 business and economics and increase student 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.

  • INTEGRATION OF EXCEL. Immediately following every statistical procedure is a sub-section that discusses how to use Excel to perform that procedure. This style enables the use of Excel to be integrated throughout the text, but still keeps the primary emphasis on the statistical methodology being discussed. 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.

  • OUTSTANDING EXERCISES. The 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" and then move on 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.

  • MARGIN ANNOTATIONS AND NOTES AND COMMENTS. Margin annotations that highlight key points and provide additional insights for the students are a key feature of this text. These annotations are designed to provide emphasis and enhance understanding of the terms and concepts being presented. At the end of many sections, we provide Notes and Comments designed to give the student 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 other matters.

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 Distribution.
6. Continuous Probability Distributions.
7. Sampling and Sampling Distributions.
8. Interval Estimation.
9. Hypothesis Testing.
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. Time Series Analysis and Forecasting.
15. Statistical Methods for Quality Control.
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 2010 and Tools for Statistical Analysis.

New to this edition

  • NEW! Integration of Microsoft Excel® 2010. Step-by-step instructions and screen captures show how to use Excel 2010 to implement statistical procedures.
  • NEW! Revised Chapter 2. Excel coverage has been condensed by moving the discussion of how to use Excel's Pivot Chart Report to chapter appendixes. Appendix 2.1 shows how to use Excel's Pivot Chart Report to summarize categorical data and Appendix 2.2 shows how to use Excel's Pivot Chart report to summarize quantitative data.
  • NEW! Revised Sampling Material. The Chapter 7 introduction has been revised and now includes the concept of a sampled population and a frame. The distinction between sampling from a finite population and an infinite population has been clarified, with sampling from an ongoing process used to illustrate the selection of a random sample from an infinite population. A practical advice section stresses the importance of obtaining close correspondence between the sampled population and the target population.
  • NEW! Revised Introduction to Hypothesis Testing. Section 9.1, Developing Null and Alternative Hypotheses, has been revised. A better set of guidelines has been developed for identifying the null and alternative hypotheses. The context of the situation and the purpose for taking the sample are key. In situations in which the focus is on finding evidence to support a research finding, the research hypothesis is the alternative hypothesis. In situations where the focus is on challenging an assumption, the assumption is the null hypothesis.
  • NEW! Section 13.8 – Modeling Curvilinear Relationships. This new section shows how curvilinear relationships can be handled easily using a multiple regression model. We illustrate the use of both Excel's Chart tools and Excel's Regression tool to fit a quadratic model.

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

CengageNOW 1-Semester Instant Access  (ISBN-10: 113357565X | ISBN-13: 9781133575658)

Succeed in your business statistics course with CengageNOW, a powerful online homework tool that optimizes your learning experience. This interactive system generates a diagnostic Personalized Study Plan (with a chapter-specific Pre-test, Study Plan, and Post-test) to help you master concepts, prepare for exams, and get a better grade

CengageNOW with eBook 2-Semester Instant Access Code  (ISBN-10: 1133575668 | ISBN-13: 9781133575665)

Succeed in your business statistics course with CengageNOW, a powerful online homework tool that optimizes your learning experience. This interactive system generates a diagnostic Personalized Study Plan (with a chapter-specific Pre-test, Study Plan, and Post-test) to help you master concepts, prepare for exams, and get a better grade

Instructor's Resource CD-ROM  (ISBN-10: 1133626017 | ISBN-13: 9781133626015)
Solutions Manual  (ISBN-10: 1133626025 | ISBN-13: 9781133626022)
EasyStat Digital Tutor for Microsoft® Excel® 2010 Instant Access Code  (ISBN-10: 1133581722 | ISBN-13: 9781133581727)

Student Supplements

CengageNOW 1-Semester Instant Access  (ISBN-10: 113357565X | ISBN-13: 9781133575658)

Succeed in your business statistics course with CengageNOW™, a powerful online homework tool that optimizes your learning experience. This interactive system generates a diagnostic Personalized Study Plan (with a chapter-specific Pre-test, Study Plan, and Post-test) to help you master concepts, prepare for exams, and get a better grade

CengageNOW with eBook 2-Semester Instant Access Code  (ISBN-10: 1133575668 | ISBN-13: 9781133575665)

Succeed in your business statistics course with CengageNOW™, a powerful online homework tool that optimizes your learning experience. This interactive system generates a diagnostic Personalized Study Plan (with a chapter-specific Pre-test, Study Plan, and Post-test) to help you master concepts, prepare for exams, and get a better grade

EasyStat Digital Tutor for Microsoft® Excel® 2010 Instant Access Code  (ISBN-10: 1133581722 | ISBN-13: 9781133581727)
LMS Integrated for Aplia, 1 term Instant Access  (ISBN-10: 1305389816 | ISBN-13: 9781305389816)

One million+ students, one billion answers In just 10 years, more than one billion answers have been submitted through Aplia, the premier online assignment solution. Millions of students use Aplia to better prepare for class and for their exams. Join them today! Know what’s important Aplia assignments mean “no surprises”—with an at-a-glance view of current assignments organized by due date, you always know what’s due, and when. Discover real-world relevance Aplia ties your lessons into real-world applications so you get a bigger, better picture of how you’ll use your education in your future workplace. Master the content Automatic grading and immediate step-by-step feedback helps you master content the right way the first time. Student Testimonial: “I was very engaged; the content in Aplia is useful. The study tools and materials in Aplia most definitely help me feel more prepared. I understood more than I would have otherwise.” - Tia Student, Glendale Community College CTA: Ask your instructor about Aplia for this course. www.cengage.com/aplia