Analyzing Business Data with Excel  

1 2

• 1. Analyzing Business Data with Excel

• 2. Table of Contents

• 3. Copyright

• 4. Preface

  Preface

• 5. Who Should Read This Book

  Who Should Read This Book

• 6. What s in This Book

  What s in This Book

• 7. How to Use This Book Effectively

  How to Use This Book Effectively

• 8. Sample Code

  Sample Code

• 9. Using Code Examples

  Using Code Examples

• 10. We d Like Your Feedback

  We d Like Your Feedback

• 11. Safari Enabled

  Safari Enabled

• 12. Acknowledgments

  Acknowledgments

• 13. Chapter 1. Excel and Statistics

  Chapter 1. Excel and Statistics

• 14. Section 1.1. Array Formulas

  1.1. Array Formulas

• 15. Section 1.2. Addressing Cells Indirectly

  1.2. Addressing Cells Indirectly

• 16. Section 1.3. Statistical Functions

  1.3. Statistical Functions

• 17. Chapter 2. Pivot Tables and Problem Solving

  Chapter 2. Pivot Tables and Problem Solving

• 18. Section 2.1. Pivot Table Basics

  2.1. Pivot Table Basics

• 19. Section 2.2. Changing the Data

  2.2. Changing the Data

• 20. Section 2.3. Pivot Table Options

  2.3. Pivot Table Options

• 21. Chapter 3. Workload Forecasting

  Chapter 3. Workload Forecasting

• 22. Section 3.1. The Procedure

  Call Volume Forecasting for Call Centers in Excel

• 23. Section 3.2. Building an Application

  3.2. Building an Application

• 24. Chapter 4. Modeling

  Chapter 4. Modeling

• 25. Section 4.1. Regression

  4.1. Regression

• 26. Section 4.2. Defining the Problem

  4.2. Defining the Problem

• 27. Section 4.3. Refining Metrics

  4.3. Refining Metrics

• 28. Section 4.4. Analysis

  4.4. Analysis

• 29. Section 4.5. Building the Model

  4.5. Building the Model

• 30. Section 4.6. Analyzing the Results

  4.6. Analyzing the Results

• 31. Section 4.7. Testing Non-Linear Relationships

  4.7. Testing Non-Linear Relationships

• 32. Chapter 5. Measuring Quality

  Chapter 5. Measuring Quality

• 33. Section 5.1. Statistical Process Control

  5.1. Statistical Process Control

• 34. Section 5.2. Running the Application

  5.2. Running the Application

• 35. Section 5.3. Application Design

  5.3. Application Design

• 36. Section 5.4. Customizing the Application

  5.4. Customizing the Application

• 37. Chapter 6. Monitoring Complex Systems

  Chapter 6. Monitoring Complex Systems

• 38. Section 6.1. The Application

  6.1. The Application

• 39. Section 6.2. The Data

  6.2. The Data

• 40. Section 6.3. Settings

  6.3. Settings

• 41. Section 6.4. Workarea

  6.4. Workarea

• 42. Section 6.5. Macros

  6.5. Macros

• 43. Chapter 7. Queuing

  Chapter 7. Queuing

• 44. Section 7.1. The Data

  7.1. The Data

• 45. Section 7.2. The Application

  7.2. The Application

• 46. Section 7.3. The Logic

  7.3. The Logic

• 47. Chapter 8. Custom Queuing Presentation

  Chapter 8. Custom Queuing Presentation

• 48. Section 8.1. The Application

  8.1. The Application

• 49. Section 8.2. The Data

  8.2. The Data

• 50. Section 8.3. The Logic

  8.3. The Logic

1 2