Description

For one-semester courses in Introduction to Business Statistics.
The gold standard in learning Microsoft Excelfor 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.

Features

Student-focused learning aids

· An integrated five-step approach makes it easier for students to follow the progression of applying statistics: Define, Collect, Organize, Visualize, Analyze.

· First Things First sets the context for explaining what statistics is (not what students may think), while ensuring that they understand why learning business statistics is important today. This chapter is especially helpful for instructors using course management tools, including hybrid or online courses; this chapter is designed for distribution before the first class begins.

· REVISED - Tabular summaries 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.

· Student Tips in the margin reinforce hard-to-master concepts and provide quick study tips for mastering important details.

· LearnMore references reinforce important points and direct students to additional learning resources.

· Additional self-study opportunities are provided in an Appendix that offers answers to the “Self-Test” problems and most of the even-numbered problems in the book.

Focus on data interpretation and application

· Analyzing data with a focus on software results: Using software is essential to learning statistics. Software should model business best practices and be integrated into the statistical learning process. Reusable templates and model solutions are emphasized over building unaudited solutions from scratch that may contain errors. Using preconstructed and previously validated solutions not only models best practice but reflects regulatory requirements that businesses face today. This text emphasizes data analysis through interpretation of the results from Microsoft® Excel®:

o Excel content includes end-of-chapter Excel Guides; in-depth Excel step-by-step instructions; Excel Guide workbooks; PHStat, a statistics add-in system for Excel; and multiple appendices devoted to Excel.

o Software instruction sets are complete and contain known starting points. Vague instructions that present statements such as “Use command X” that presume students can figure out how to “get to” command X are distracting to learning. Instruction sets are provided that have a known starting point, typically in the form of “open to a specific worksheet in a specific workbook.”

o NEW - Tableau Guides in each chapter explain how to use Tableau Public, the data visualization software, as a complement to Microsoft Excel for visualizing data. The text offers Tableau Public results for selected methods in which Tableau can enhance or complement Excel results.

· REVISED - Using Statistics business scenarios begin each chapter. Scenarios are then used throughout the chapter to provide an applied context for the concepts, to bring students from knowing to applying. In the 9th Edition, Global Edition, seven chapters offer new or revised case scenarios.

o Help students see the relevance of statistics to their own careers by using examples from the functional areas that may become their areas of specialization. Every statistical method is discussed using an example from a functional area, such as accounting, finance, management, or marketing, and explaining the application of methods to specific business acti

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.

Table of Contents

• 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