Analyzing business data with Excel
As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is t...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media
2006.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627217206719 |
Tabla de Contenidos:
- Analyzing Business Data with Excel; What&s in This Book; How to Use This Book Effectively; Sample Code; Using Code Examples; We&d Like Your Feedback!; Safari® Enabled; Acknowledgments; 1. Excel and Statistics; 1.2. Addressing Cells Indirectly; 1.3. Statistical Functions; 1.3.1.2. DAVERAGE; 1.3.1.3. Trimmed average; 1.3.1.4. Moving average; 1.3.2. Changes in the Average; 1.3.3. Distributions; 1.3.3.2. Exponential distributions; 1.3.3.3. Gamma distribution; 1.3.3.4. Binomial distribution; 1.3.4. Correlation; 2. Pivot Tables and Problem Solving; 2.1.2. Sorting and Filtering
- 2.1.3. Multiple Data Items2.1.4. Working with Rows and Columns; 2.1.5. Adding a PivotChart; 2.1.6. Multiple Layers and Pages; 2.1.7. Drilling Down; 2.2. Changing the Data; 2.2.2. Scalar Information; 2.3. Pivot Table Options; 3. Workload Forecasting; 3.1.2. Predictions; 3.1.2.2. Find the average; 3.1.2.3. Adjust for the trend; 3.1.3. Determine the Confidence Interval; 3.1.4. Manage Anomalies; 3.2. Building an Application; 3.2.2. List the Requirements; 3.2.3. Consider the Source of Data; 3.2.4. Presentation; 3.2.5. Conventions and Names; 3.2.6. Named Values and Ranges on Settings
- 3.2.7. The Named Values on the Workarea Sheet3.2.8. Named Ranges on Workarea; 3.2.9. Other Important Links on Workarea; 3.2.10. Linking to the Data; 3.2.11. Visual Basic; 3.2.12. Formatting; 3.2.13. Running the Application; 3.2.14. Customizing the Application; 4. Modeling; 4.2. Defining the Problem; 4.3. Refining Metrics; 4.4. Analysis; 4.5. Building the Model; 4.6. Analyzing the Results; 4.7. Testing Non-Linear Relationships; 5. Measuring Quality; 5.1.2. X and S Charts; 5.2. Running the Application; 5.3. Application Design; 5.3.2. The Workarea Sheet; 5.3.3. The Controls on the Display Sheet
- 5.3.4. Linking the Workarea Sheet to the Data Sheet5.3.5. The Display Sheet; 5.3.5.2. Other parts of the Display sheet; 5.4. Customizing the Application; 5.4.2. Adding Logic; 5.4.3. Adding a Macro; 6. Monitoring Complex Systems; 6.2. The Data; 6.3. Settings; 6.3.2. The Alternate; 6.3.3. The Lag; 6.3.4. The Out of Limits Message; 6.3.5. The Current Column; 6.3.6. The Current Row; 6.3.7. The Sensitivity; 6.4. Workarea; 6.4.2. Columns Used; 6.4.3. LastColumn; 6.4.4. StartRow; 6.4.5. IsOut; 6.4.6. The Data Area; 6.4.7. The Regression Area; 6.4.8. The Combo Box Data Area
- 6.4.9. The Main Display Area6.5. Macros; 7. Queuing; 7.2. The Application; 7.3. The Logic; 7.3.2. Invisible Rectangles; 7.3.3. The Agent Detail Area; 7.3.4. The Chart Area; 7.3.5. The Timeline; 7.3.6. Navigation; 8. Custom Queuing Presentation; 8.2. The Data; 8.3. The Logic; 8.4. VBA; 8.5. Extending the Application; 9. Optimizing; 9.1.2. A Quadratic Equation; 9.1.3. A Matrix Problem; 9.1.4. Using Goal Seek in a Macro; 9.2. The Solver; 9.2.2. Regression with the Solver; 9.2.3. A Problem with Constraints; 9.2.4. Zero/One Problem; 9.2.5. Running the Solver with a Macro
- 9.2.6. Common Problems with the Solver
