Data analysis and business modeling

Microsoft Excel Data Analysis and Business Modeling
by Wayne L. Winston   ISBN:0735619018
Microsoft Press © 2004 (616 pages)
Use this resource to apply the techniques that business analysts at leading companies use to analyze and transform data into bottom line results, and use Microsoft Excel for data analysis, modeling, and decision making.
 
Table of Contents

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