| Description |
1 online resource (262 pages) |
| Contents |
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 |
| Summary |
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 there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel f |
| Notes |
Copyright © O'Reilly Media, Inc. 2006 |
|
Print version record |
| SUBJECT |
880-01 Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
880-01/(2/r אקסל (גליון אלקטרוני) |
|
Microsoft Excel (Computer file) blmlsh |
|
Microsoft Excel (Computer file) fast |
| Subject |
Commercial statistics -- Computer programs
|
|
MATHEMATICS -- Probability & Statistics -- General.
|
|
Commercial statistics -- Computer programs.
|
|
Commercial statistics -- Computer programs
|
| Form |
Electronic book
|
| LC no. |
2006274613 |
| ISBN |
0596100736 |
|
9780596100735 |
|
9780596518646 |
|
0596518641 |
|
9780596553463 |
|
0596553463 |
|
