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
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 1.2 Install SSH Windows Clients to Access Remote Machines Securely
Step 4.3 How to Generate a Key Pair Using OpenSSH
Step 4.5 How to use OpenSSH Passphrase Agents
Step 6.1 Port Forwarding
Step 6.2 Using Port Forwarding Within PuTTY to Read Your E-mail Securely
C++ GUI Programming with Qt 3
Rapid Dialog Design
Subclassing QMainWindow
Setting Up the Status Bar
Graphics with OpenGL
Using QTextBrowser as a Simple Help Engine
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Individual change
Part II - The Applications
Mergers and acquisitions
IT-based process change
Microsoft VBScript Professional Projects
Errors, Constants, and Variables
Maintaining a 30-Day Summary Log Archive
Designing the Web Site
Building the Web Sites Main Page
Appendix B Whats on the Companion Web Site
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
Using the Database for Job Storage
Creating a Quartz Plug-In
Using the RMI Registry
Testing the RMI Server and Client
Running the Quartz Cluster Nodes
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Designing with Classes and Tiers
Control Class Basics
Design-Time Support for Custom Controls
Data Controls
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