ptg18466955
iv Contents at a Glance
CHAPTER 29 An introduction to optimization with Excel Solver 269
CHAPTER 30 Using Solver to determine the optimal product mix 273
CHAPTER 31 Using Solver to schedule your workforce 285
CHAPTER 32 Using Solver to solve transportation or distribution
problems 291
CHAPTER 33 Using Solver for capital budgeting 297
CHAPTER 34 Using Solver for nancial planning 305
CHAPTER 35 Using Solver to rate sports teams 311
CHAPTER 36 Warehouse location and the GRG Multistart and
Evolutionary Solver engines 317
CHAPTER 37 Penalties and the Evolutionary Solver 327
CHAPTER 38 The traveling salesperson problem 333
CHAPTER 39 Importing data from a text le or document 337
CHAPTER 40 Validating data 343
CHAPTER 41 Summarizing data by using histograms and Pareto charts 351
CHAPTER 42 Summarizing data by using descriptive statistics 365
CHAPTER 43 Using PivotTables and slicers to describe data 383
CHAPTER 44 The Data Model 429
CHAPTER 45 Power Pivot 439
CHAPTER 46 Power View and 3D Maps 451
CHAPTER 47 Sparklines 465
CHAPTER 48 Summarizing data with database statistical functions 471
CHAPTER 49 Filtering data and removing duplicates 481
CHAPTER 50 Consolidating data 495
CHAPTER 51 Creating subtotals 501
CHAPTER 52 Charting tricks 507
CHAPTER 53 Estimating straight-line relationships 543
CHAPTER 54 Modeling exponential growth 551
CHAPTER 55 The power curve 555
CHAPTER 56 Using correlations to summarize relationships 561
CHAPTER 57 Introduction to multiple regression 567
CHAPTER 58 Incorporating qualitative factors into multiple regression 575
CHAPTER 59 Modeling nonlinearities and interactions 585
CHAPTER 60 Analysis of variance: One-way ANOVA 593
CHAPTER 61 Randomized blocks and two-way ANOVA 599
CHAPTER 62 Using moving averages to understand time series 609
