Safari Books Online: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

Table of Contents

Home
Subscribe
Free Trial

Category Map
My Quick Links
Books
Video
Rough Cuts
Short Cuts
Tools

Search:criteria:

Title=Bold Reference Entry=Italic

Advanced Search

This Book

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

Search

search in
search for

Contents

Table of Contents

Introduction to Excel 2007: What’s New?

Ch. 1. Range Names

Ch. 2. Lookup Functions

Ch. 3. The INDEX Function

Ch. 4. The MATCH Function

Ch. 5. Text Functions

Ch. 6. Dates and Date Functions

Ch. 7. Evaluating Investments by Using Net Present Value Criteria

Ch. 8. Internal Rate of Return

Ch. 9. More Excel Financial Functions

Ch. 10. Circular References

Ch. 11. IF Statements

Ch. 12. Time and Time Functions

Ch. 13. The Paste Special Command

Ch. 14. The Auditing Tool

Ch. 15. Sensitivity Analysis with Data Tables

Ch. 16. The Goal Seek Command

Ch. 17. Using the Scenario Manager for Sensitivity Analysis

Ch. 18. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions

Ch. 19. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions

Ch. 20. The OFFSET Function

Ch. 21. The INDIRECT Function

Ch. 22. Conditional Formatting

Ch. 23. Sorting in Excel

Ch. 25. Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes

Ch. 26. An Introduction to Optimization with Excel Solver

Ch. 27. Using Solver to Determine the Optimal Product Mix

Ch. 28. Using Solver to Schedule Your Workforce

Ch. 29. Using Solver to Solve Transportation or Distribution Problems

Ch. 30. Using Solver for Capital Budgeting

Ch. 31. Using Solver for Financial Planning

Ch. 32. Using Solver to Rate Sports Teams

Ch. 33. Importing Data from a Text File or Document

Ch. 34. Importing Data from the Internet

Ch. 35. Validating Data

Ch. 36. Summarizing Data by Using Histograms

Ch. 37. Summarizing Data by Using Descriptive Statistics

Ch. 38. Using PivotTables to Describe Data

Ch. 39. Summarizing Data with Database Statistical Functions

Ch. 40. Filtering Data and Removing Duplicates

Ch. 41. Consolidating Data

Ch. 42. Creating Subtotals

Ch. 43. Estimating Straight Line Relationships

Ch. 44. Modeling Exponential Growth

Ch. 45. The Power Curve

Ch. 46. Using Correlations to Summarize Relationships

Ch. 47. Introduction to Multiple Regression

Ch. 48. Incorporating Qualitative Factors into Multiple Regression

Ch. 49. Modeling Nonlinearities and Interactions

Ch. 50. Analysis of Variance: One-Way ANOVA

Ch. 51. Randomized Blocks and Two-Way ANOVA

Ch. 52. Using Moving Averages to Understand Time Series

Ch. 53. Winter’s Method

Ch. 54. Forecasting in the Presence of Special Events

Ch. 55. An Introduction to Random Variables

Ch. 56. The Binomial, Hypergeometric, and Negative Binomial Random Variables

Ch. 57. The Poisson and Exponential Random Variable

Ch. 58. The Normal Random Variable

Ch. 59. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project

Ch. 60. Introduction to Monte Carlo Simulation

Ch. 61. Calculating an Optimal Bid

Ch. 62. Simulating Stock Prices and Asset Allocation Modeling

Ch. 63. Fun and Games: Simulating Gambling and Sporting Event Probabilities

Ch. 64. Using Resampling to Analyze Data

Ch. 65. Pricing Stock Options

Ch. 66. Determining Customer Value

Ch. 67. The Economic Order Quantity Inventory Model

Ch. 68. Inventory Modeling with Uncertain Demand

Ch. 69. Queuing Theory: The Mathematics of Waiting in Line

Ch. 70. Estimating a Demand Curve

Ch. 71. Pricing Products by Using Tie-Ins

Ch. 72. Pricing Products by Using Subjectively Determined Demand

Ch. 73. Nonlinear Pricing

Ch. 74. Array Formulas and Functions

About the Author

Create BookmarkCreate Bookmark
Create Note or TagCreate Note or Tag
DownloadDownload
Email This PageEmail This Page
PrintPrint

Thumbnail View (Key: v)
Zoom Out (Key: -)Zoom Out
Zoom In (Key: +)Zoom In
Fit WidthFit Width
Fit PageFit Page
Previous (Key: p)Previous
Next (Key: n)Next

URL

Show search terms

Help

Chapter 17. Using the Scenario Manager for Sensitivity Analysis - Pg. 115

You are viewing the content on this page in Preview Mode.

Sign In, Subscribe or
Register For a Free Trial
to access full content of this book.