Analyzing Business Data with Excel
Analyzing Business Data with Excel
ISBN: 0596100736
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 101
Pages: 101
Authors: Gerald Knight
- Analyzing Business Data with Excel
- Table of Contents
- Copyright
- Preface
- Who Should Read This Book
- What s in This Book
- How to Use This Book Effectively
- Sample Code
- Using Code Examples
- We d Like Your Feedback
- Safari Enabled
- Acknowledgments
- Chapter 1. Excel and Statistics
- Section 1.1. Array Formulas
- Section 1.2. Addressing Cells Indirectly
- Section 1.3. Statistical Functions
- Chapter 2. Pivot Tables and Problem Solving
- Section 2.1. Pivot Table Basics
- Section 2.2. Changing the Data
- Section 2.3. Pivot Table Options
- Chapter 3. Workload Forecasting
- Section 3.1. The Procedure
- Section 3.2. Building an Application
- Chapter 4. Modeling
- Section 4.1. Regression
- Section 4.2. Defining the Problem
- Section 4.3. Refining Metrics
- Section 4.4. Analysis
- Section 4.5. Building the Model
- Section 4.6. Analyzing the Results
- Section 4.7. Testing Non-Linear Relationships
- Chapter 5. Measuring Quality
- Section 5.1. Statistical Process Control
- Section 5.2. Running the Application
- Section 5.3. Application Design
- Section 5.4. Customizing the Application
- Chapter 6. Monitoring Complex Systems
- Section 6.1. The Application
- Section 6.2. The Data
- Section 6.3. Settings
- Section 6.4. Workarea
- Section 6.5. Macros
- Chapter 7. Queuing
- Section 7.1. The Data
- Section 7.2. The Application
- Section 7.3. The Logic
- Chapter 8. Custom Queuing Presentation
- Section 8.1. The Application
- Section 8.2. The Data
- Section 8.3. The Logic
- Section 8.4. VBA
- Section 8.5. Extending the Application
- Chapter 9. Optimizing
- Section 9.1. Goal Seek
- Section 9.2. The Solver
- Chapter 10. Importing Data
- Section 10.1. Text Files
- Section 10.2. Databases
- Section 10.3. XML
- Chapter 11. The Trouble with Data
- Section 11.1. Numbers
- Section 11.2. Dates
- Section 11.3. Reports
- Section 11.4. Equivalence
- Chapter 12. Effective Display Techniques
- Section 12.1. Respect the Information and the Audience
- Section 12.2. Large Worksheets
- Section 12.3. Charts
- Section 12.4. Pictures and Other Objects
- Section 12.5. Complexity
- Section 12.6. Repeated Elements
- Section 12.7. Information Density
- Section 12.8. Emphasis and Focus
- About the Author
- Colophon
- Index
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- V
- W
- X
- Z
Analyzing Business Data with Excel
ISBN: 0596100736
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 101
Pages: 101
Authors: Gerald Knight