Statistics for Managers Using Microsoft Excel, Global Edition, 9th edition

Published by Pearson (June 8, 2020) © 2020

  • David M. Levine Baruch College, City University of New York
  • David F. Stephan Two Bridges Instructional Technology
  • Kathryn A. Szabat La Salle University
Products list
Products list
For one-semester courses in Introduction to Business Statistics.
The gold standard in learning Microsoft Excel for business statistics
Statistics for Managers Using Microsoft Excel, 9th Edition, Global Edition helps students develop the knowledge of Excel needed in future careers. The authors present statistics in the context of specific business fields, and now include a full chapter on business analytics. Guided by principles set forth by ASA's Guidelines for Assessment and Instruction (GAISE) reports and the authors' diverse teaching experiences, the text continues to innovate and improve the way this course is taught to students. Current data throughout gives students valuable practice analysing the types of data they will see in their professions, and the authors' friendly writing style includes tips and learning aids throughout.

Samples

Download the detailed table of contents

Preview sample pages from Statistics for Managers Using Microsoft Excel

Features

  • Using Statistics case scenarios - Each chapter begins with a Using Statistics case scenario that presents a business problem or goal that illustrates the application of business statistics to provide actionable information. For many chapters, scenarios also provide the scaffolding for learning a series of related statistical methods. End-of-chapter 'Revisited' sections reinforce the statistical learning of a chapter by discussing how the methods and techniques can be applied to the goal or problem that the case scenario considers.
  • Emphasis on interpretation of the data analysis results - Statistics for Managers Using Microsoft Excel was among the first introductory business statistics textbooks to focus on the interpretation of Microsoft Excel statistical results. This tradition continues, now supplemented by Tableau (Public) results for selected methods in which Tableau can enhance or complement Excel results.
  • Software integration and flexibility - Software instructions feature chapter examples and were personally written by the authors, who collectively have more than one hundred years of experience teaching the application of business software. With modularised Workbook, PHStat, and where applicable, Analysis Toolbook instructions, both instructors and students can switch among these instruction sets as they use this book with no loss of statistical learning.
  • Unique Excel workbooks - Statistics for Managers Using Microsoft Excel comes with Excel Guide workbooks that illustrate model solutions and provide template solutions to selected methods and Visual Explorations, macro-enhanced workbooks that demonstrate selected basic concepts. This book is fully integrated with PHStat, the Pearson statistical add-in for Excel that places the focus on statistical learning that the authors designed and developed.
  • In chapter and end-of-chapter reinforcements - Exhibits summarise key processes throughout the book. A key terms list provides an index to the definitions of the important vocabulary of a chapter. 'Learning the Basics' questions test the basic concepts of a chapter. 'Applying the Concepts' problems test the learner's ability to apply statistical methods to business problems. And, for the more mathematically minded, 'Key Equations' list the boxed number equations that appear in a chapter.
  • End-of-chapter cases include a case that continues through most chapters and several cases that reoccur throughout the book. 'Digital Cases' require students to examine business documents and other information sources to sift through various claims and discover the data most relevant to a business case problem. Many of these cases also illustrate common misuses of statistical information. 
  • Answers to even-numbered problems - An appendix provides additional self-study opportunities by provides answers to the 'Self-Test' problems and most of the even-numbered problems in this book
  • Opportunities for additional learning - In-margin student tips and Learn More references reinforce important points and direct students to additional learning resources. In-chapter Consider This essays reinforce important concepts, examine side issues, or answer questions that arise while studying business statistics, such as 'What is so 'normal' about the normal distribution?'
  • Highly tailorable content - With an extensive library of separate online topics, sections, and even two full chapters, instructors can combine these materials and the opportunities for additional learning to meet their curricular needs.

New to this edition

  • New or revised Using Statistics case scenarios in seven chapters of the 9th Edition, Global Edition. These business scenarios begin each chapter, showing how statistics is used in accounting, finance, information systems, management, or marketing. Scenarios are then used throughout the chapter to provide an applied context for the concepts, to bring students from knowing to applying.
  • New Tableau Guides in each chapter explain how to use the data visualisation software Tableau Public as a complement to Microsoft Excel for visualising data. The text offers Tableau Public results for selected methods in which Tableau can enhance or complement Excel results.
  • A new Business Analytics chapter (Chapter 17) provides a complete introduction to the field of business analytics. The chapter defines terms and categories that introductory business statistics students may encounter in other courses or outside the classroom.
  • Includes a new Consider This feature, 'What's My Major If I Want to Be a Data Miner?'
  • Exercises have been reviewed, updated, and replaced in this edition.
  • Tabular summaries now guide readers to reaching conclusions and making decisions based on statistical information. Found in Chapters 10 through 13, this change not only adds clarity to the purpose of the statistical method being discussed but better illustrates the role of statistics in business decision-making processes.
  • 1 Defining and Collecting Data
  • 2 Organizing and Visualizing Variables
  • 3 Numerical Descriptive Measures
  • 4 Basic Probability
  • 5 Discrete Probability Distributions
  • 6 The Normal Distribution and Other Continuous Distributions
  • 7 Sampling Distributions
  • 8 Confidence Interval Estimation
  • 9 Fundamentals of Hypothesis Testing: One-Sample Tests
  • 10 Two-Sample Tests
  • 11 Analysis of Variance
  • 12 Chi-Square and Nonparametric Tests
  • 13 Simple Linear Regression
  • 14 Introduction to Multiple Regression
  • 15 Multiple Regression Model Building
  • 16 Time-Series Forecasting
  • 17 Business Analytics
  • 18 Getting Ready to Analyze Data in the Future

Download the detailed table of contents

Need help? Get in touch