## Book Description

Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenarios.

1. Microsoft® Excel Data Analysis and Business Modeling
2. A Note Regarding Supplemental Files
3. Introduction
1. What You Should Know Before Reading This Book
2. How to Use This Book
3. Support Information
4. Acknowledgments
4. 1. Range Names
1. How Can I Create Range Names?
2. How Do I Delete a Range Name?
3. How Do I Change a Range Name?
4. How Do I Name a Constant?
5. Remarks
6. Problems
5. 2. Natural Language Range Names
6. 3. Lookup Functions
1. Syntax of the LOOKUP Functions
2. HLOOKUP Syntax
3. Problems
7. 4. The INDEX Function
1. Syntax of the INDEX Function
2. Problems
8. 5. The MATCH Function
9. 6. Text Functions
1. Text Function Syntax
2. Text Functions in Action
3. Using the Text To Columns Command to Extract Data
4. Problems
10. 7. Dates and Date Functions
11. 8. Evaluating Investments with Net Present Value Criteria
12. 9. Internal Rate of Return
13. 10. Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions
14. 11. Circular References
15. 12. IF Statements
16. 13. The Paste Special Command
17. 14. The Auditing Tool
18. 15. Sensitivity Analysis with Data Tables
19. 16. The Goal Seek Command
20. 17. Using the Scenario Manager for Sensitivity Analysis
21. 18. Creating and Using Spinners for Sensitivity Analysis
22. 19. The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions
23. 20. The SUMIF Function
24. 21. The OFFSET Function
25. 22. The INDIRECT Function
26. 23. Conditional Formatting
27. 24. An Introduction to Optimization with the Excel Solver
28. 25. Using Solver to Determine the Optimal Product Mix
29. 26. Using Solver to Solve Transportation or Distribution Problems
30. 27. Using Solver to Schedule Your Workforce
31. 28. Using Solver for Capital Budgeting
32. 29. Using Solver for Financial Planning
33. 30. Using Solver to Rate Sports Teams
34. 31. Importing Text or Microsoft Word Data into Excel
35. 32. Importing Data from the Web into Excel
36. 33. Validating Data
37. 34. Summarizing Data with Histograms
38. 35. Summarizing Data with Descriptive Statistics
39. 36. Using PivotTables to Describe Data
40. 37. Summarizing Data with Database Statistical Functions
41. 38. Filtering Data
42. 39. Consolidating Data
43. 40. Creating Subtotals
44. 41. Estimating Straight Line Relationships
45. 42. Modeling Exponential Growth
46. 43. The Power Curve
47. 44. Using Correlations to Summarize Relationships
48. 45. Introduction to Multiple Regression
49. 46. Incorporating Qualitative Factors into Multiple Regression
50. 47. Modeling Nonlinearities and Interactions
51. 48. Analysis of Variance: One-Way ANOVA
52. 49. Randomized Blocks and Two-Way ANOVA
53. 50. Using Moving Averages to Understand Time Series
54. 51. Forecasting with Moving Averages
55. 52. Forecasting in the Presence of Special Events
56. 53. An Introduction to Random Variables
57. 54. The Binomial and Hypergeometric Random Variables
58. 55. The Poisson and Exponential Random Variable
59. 56. The Normal Random Variable
60. 57. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
61. 58. Introduction to Monte Carlo Simulation
1. Who uses Monte Carlo simulation?
2. What happens when I enter =RAND() in a cell?
3. How can I simulate values of a discrete random variable?
4. How can I simulate values of a normal random variable?
5. How should a greeting card company determine how many cards to produce?
6. Problems
62. 59. Calculating an Optimal Bid
63. 60. Simulating Stock Prices and Asset Allocation Modeling
64. 61. Fun and Games: Simulating Gambling and Sporting Event Probabilities
65. 62. Using Resampling to Analyze Data
66. 63. Pricing Stock Options
67. 64. Determining Customer Value
68. 65. The Economic Order Quantity Inventory Model
69. 66. Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder?
70. 67. Queuing Theory: The Mathematics of Waiting in Line
71. 68. Estimating a Demand Curve
72. 69. Pricing Products with Tie-Ins
73. 70. Pricing Products Using Subjectively Determined Demand
74. 71. Nonlinear Pricing
75. 72. Array Formulas and Functions
76. 73. Picking Your Fantasy Football Team