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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Overview of Java UI Toolkits and SWT/JFace
Menus, Toolbars, Cool, Bars, and Actions
Trees
SWT Graphics and Image Handling
Drawing Diagrams with Draw2D
GO! with Microsoft Office 2003 Brief (2nd Edition)
Project 1A. Exploring Outlook 2003
Project 1A. College and Career Information
Key Terms
Objective 2. Start Access, Open an Existing Database, and View Database Objects
Objective 4. Import Text from Word
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Basic ImageReady Animation, Tweening, and Layer Styles
Rotoscoping Techniques with Photoshop
Scale and Speed
Custom Scene Transitions
Appendix Adobe Photoshop and After Effects Resources
Extending and Embedding PHP
Summary
Complex Structures
The Evolution of the PHP Object Type
Speaking the Windows Dialect
Summary
.NET-A Complete Development Cycle
Implementing the SmartNotes Application
References for Further Reading
Design of the Photo Editor Application
GDI+ Graphics Extensions
Conclusion
Programming .Net Windows Applications
User Interface Design
The Analog Clock Project
Text
DateTimePicker
Assemblies
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