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
Developing Tablet PC Applications (Charles River Media Programming)
Introduction to the VB .NET Language
Strings, GDI+, and Error Handling in VB .NET
Speech Input with SAPI
Storing Ink in a Database
3D Rendering with OpenGL and DirectX 9
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Common Configuration Items
Asynchronous Interfaces
Distance-Vector and Link-State Routing Protocols
EIGRP
Modern IOS QoS Tools
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Increasing Persuasion through Mobility and Connectivity
The Ethics of Persuasive Technology
Captology Looking Forward
Junos Cookbook (Cookbooks (OReilly))
Backing Up the Routers Configuration
Allowing Access to the Router
Setting the Routers Source Address
Creating Static Routes
Controlling DIS Election
FileMaker 8 Functions and Scripts Desk Reference
Number Functions
Text Formatting Functions
Get(CustomMenuSetName)
Get(ScriptName)
Get(StatusAreaState)
GDI+ Programming with C#
System Pens and System Brushes
Transforming Text
Working with Images
Blending Explained
Your First Printing Application
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