Flylib.com
Analyzing Business Data with Excel
Analyzing Business Data with Excel
ISBN: 0596100736
EAN: 2147483647
Year: 2006
Pages: 101
Authors:
Gerald Knight
BUY ON AMAZON
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
Year: 2006
Pages: 101
Authors:
Gerald Knight
BUY ON AMAZON
ERP and Data Warehousing in Organizations: Issues and Challenges
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Data Mining for Business Process Reengineering
Healthcare Information: From Administrative to Practice Databases
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
Development of Interactive Web Sites to Enhance Police/Community Relations
The .NET Developers Guide to Directory Services Programming
Understanding Searching Timeouts
Security in Directory Services Programming
Locating Domain Controllers
Expanding Group Membership
Error 0x8007202F: A constraint violation occurred.
Microsoft VBScript Professional Projects
Mapping Network Printers and Disks
Project Case Study Analyzing Application Logs
Developing Script Log Analyzers
Reporting Application Summary Data via the Web
Converting Reports to HTML Pages
Extending and Embedding PHP
Data Conversion
Configuring PHP for Development
Implementing Classes
Calling Back into PHP
Array Manipulation
Quantitative Methods in Project Management
Introduction to Probability and Statistics for Projects
Making Quantitative Decisions
Expense Accounting and Earned Value
Quantitative Time Management
Quantitative Methods in Project Contracts
Python Programming for the Absolute Beginner, 3rd Edition
Climbing the GUI Learning Curve
The PyErrata Web Site
Roses Are Red, Violets Are Blue; Lists Are Mutable, and So Is Class Foo
Enter Python
So What s Python The Sequel
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies