Analyzing business data with Excel / Gerald Knight.

Format:

Book

Author/Creator:

Knight, Gerald.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Commercial statistics--Computer programs.

Commercial statistics.

Physical Description:

1 online resource (264 p.)

Edition:

First edition.

Place of Publication:

Sebastopol, California : O'Reilly Media, 2006.

Language Note:

English

System Details:

text file

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

Contents:

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

Notes:

Includes index.

Description based on print version record.

ISBN:

9780596518646

0596518641

9780596553463

0596553463

OCLC:

609841232