About the Book

Master data analysis, modeling and the effective use of spreadsheets with the popular BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 7E. The quantitative methods approach in this edition helps you maximize your success with a proven teach-by-example presentation, inviting writing style and complete integration of the latest version of Excel. The approach is also compatible with earlier versions of Excel for your convenience. This edition is more data-oriented than ever before with a new chapter on the two main Power BI tools in Excel -- Power Query and Power Pivot -- and a new section of data visualization with Tableau Public. Current problems and cases demonstrate the importance of the concepts you are learning. In addition, a useful Companion Website provides data and solutions files, Solver Table for optimization sensitivity analysis and Palisade Decision Tools Suite.

Contents

Preface

1 Introduction to Business Analytics

Part 1 Data Analysis

2 Describing the Distribution of a Variable

3 Finding Relationships among Variable

4 Business Intelligence (BI) Tools for Data Analysis

Part 2 Probability and Decision Making under Uncertainty

5 Probability and Probability Distributions

6 Decision Making under Uncertainly

Part 3 Statistical Inference

7 Sampling and Sampling Distributions

8 Confidence Interval Estimation

9 Hypothesis Testing

Part 4 Regression Analysis and Time Series Forecasting

10 Regression Analysis: Estimating Relationships

11 Regression Analysis: Statistical Inference

12 Time Series Analysis and Forecasting

Part 5 Optimization and Simulation Modeling

13 Introduction to optimization Modeling

14 Optimization Models

15 Introduction to Simulation Modeling

16 Simulation Models

Part 6 Advanced Data Analysis

17 Data Mining

18 Analysis of Variance and Experimental Design (MindTap Reader only)

19 Statistical Process Control (MindTap Reader only)

 APPENDIX A: Quantitative Reporting (MindTap Reader only)

Reference

Index