Cargando…
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 that...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2006.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Copyright; Table of Contents; Preface; Who Should Read This Book; What's in This Book; How to Use This Book Effectively; Typographical Conventions; Sample Code; Using Code Examples; We'd Like Your Feedback!; Safari® Enabled; Acknowledgments; Excel and Statistics; Array Formulas; Addressing Cells Indirectly; Statistical Functions; The Average; AVERAGEA; DAVERAGE; Trimmed average; Moving average; Changes in the Average; Growth; Distributions; Normal distributions; Exponential distributions; Gamma distribution; Binomial distribution; Correlation; Pivot Tables and Problem Solving.
- Pivot Table BasicsPopulating the Table; Sorting and Filtering; Multiple Data Items; Working with Rows and Columns; Adding a PivotChart; Multiple Layers and Pages; Drilling Down; Changing the Data; Categorical Information; Scalar Information; Pivot Table Options; Workload Forecasting; The Procedure; Data; Predictions; Find the lag; Find the average; Adjust for the trend; Determine the Confidence Interval; Manage Anomalies; Building an Application; Design; List the Requirements; Consider the Source of Data; Presentation; Conventions and Names; Named Values and Ranges on Settings.
- The Named Values on the Workarea SheetNamed Ranges on Workarea; Other Important Links on Workarea; Linking to the Data; Visual Basic; Formatting; Running the Application; Customizing the Application; Modeling; Regression; Defining the Problem; Refining Metrics; Analysis; Building the Model; Analyzing the Results; Testing Non-Linear Relationships; Measuring Quality; Statistical Process Control; Choosing Metrics; X and S Charts; Running the Application; Application Design; The Data Sheet; The Workarea Sheet; The Controls on the Display Sheet; Linking the Workarea Sheet to the Data Sheet.
- Calculations on the Workarea SheetThe Display Sheet; The scroll; Other parts of the Display sheet; Customizing the Application; Changing the Display Sheet; Adding Logic; Adding a Macro; Monitoring Complex Systems; The Application; The Data; Settings; Independent Columns; The Alternate; The Lag; The Out of Limits Message; The Current Column; The Current Row; The Sensitivity; Workarea; LastRow; Columns Used; LastColumn; StartRow; IsOut; The Data Area; The Regression Area; The Combo Box Data Area; The Main Display Area; Macros; Queuing; The Data; The Application; The Logic.
- Using a Tag Sort on Linked InformationInvisible Rectangles; The Agent Detail Area; The Chart Area; The Timeline; Navigation; Custom Queuing Presentation; The Application; The Data; The Logic; VBA; Extending the Application; Optimizing; Goal Seek; Setting a Price; A Quadratic Equation; A Matrix Problem; Using Goal Seek in a Macro; The Solver; Finding Two Values at Once; Regression with the Solver; A Problem with Constraints; Zero/One Problem; Running the Solver with a Macro; Common Problems with the Solver; Applications; Importing Data; Text Files; Fixed Length Files; Delimited Files.