Squibb, Cisco Systems,, eBay, Eli Lilly, Ford, General Electric, General Motors, Since 1999, I’ve taught thousands of analysts at organizations such as 3M, Bristol-Myers Profits, reduce costs, or manage operations more efficiently. It might also involve building analytic models to help your employer increase Your job probably involves summarizing, reporting, andĪnalyzing data. Or a not-for-profit organization, if you’re reading this introduction the chances are you use Whether you work for a Fortune 500 corporation, a small company, a government agency, 565ħ2 Fun and Games: Simulating Gambling and SportingĮvent Probabilities. 559ħ1 Simulating Stock Prices and Asset Allocation Modeling.
545Ħ9 Introduction to Monte Carlo Simulation. 541Ħ8 Using the Lognormal Random Variable to Model 535Ħ7 Making Probability Statements from Forecasts. 527Ħ6 Weibull and Beta Distributions: Modeling Machine LifeĪnd Duration of a Project. 515Ħ4 The Poisson and Exponential Random Variable. 509Ħ3 The Binomial, Hypergeometric, and Negative Binomial 501Ħ2 An Introduction to Random Variables. 497Ħ1 Forecasting in the Presence of Special Events. 491Ħ0 Ratio-to-Moving-Average Forecast Method. 477ĥ8 Using Moving Averages to Understand Time Series. 471ĥ7 Randomized Blocks and Two-Way ANOVA. 463ĥ6 Analysis of Variance: One-Way ANOVA. 453ĥ5 Modeling Nonlinearities and Interactions. 447ĥ4 Incorporating Qualitative Factors into Multiple 441ĥ3 Introduction to Multiple Regression. 435ĥ2 Using Correlations to Summarize Relationships. 417Ĥ9 Estimating Straight Line Relationships. 387Ĥ6 Filtering Data and Removing Duplicates. 381Ĥ5 Summarizing Data with Database Statistical Functions. 335Ĥ3 Using PivotTables and Slicers to Describe Data. 327Ĥ2 Summarizing Data by Using Descriptive Statistics. 319Ĥ1 Summarizing Data by Using Histograms. 303ģ8 Importing Data from a Text File or Document. 287ģ6 Penalties and the Evolutionary Solver. 281ģ5 Warehouse Location and the GRG Multistart andĮvolutionary Solver Engines. 267ģ3 Using Solver for Financial Planning. 261ģ2 Using Solver for Capital Budgeting. 255ģ1 Using Solver to Solve Transportation or Distribution 245ģ0 Using Solver to Schedule Your Workforce. 241Ģ9 Using Solver to Determine the Optimal Product Mix. 229Ģ8 An Introduction to Optimization with Excel Solver. 217Ģ7 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes,Ĭombo Boxes, and Group List Boxes. 149Ģ1 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFSįunctions. 143Ģ0 The COUNTIF, COUNTIFS, COUNT, COUNTA, andĬOUNTBLANK Functions. 137ġ9 Using the Scenario Manager for Sensitivity Analysis. 121ġ7 Sensitivity Analysis with Data Tables. Technical Reviewer: M tch Tu och Techn ca Rev ew serv ces prov ded by Content Master,ġ5 Three-Dimensional Formulas. Th s book expresses the author’s v ews and op n ons The nformat on conta ned n th s book s prov ded w thoutĪny express, statutory, or mp ed warrant es Ne ther the authors, M crosoft Corporat on, nor ts rese ers, orĭ str butors w be he d ab e for any damages caused or a eged to be caused e ther d rect y or nd rect y byĮditorial and Production: John P erce and Waypo nt Press The examp e compan es, organ zat ons, products, doma n names, e-ma addresses, ogos, peop e, p aces, andĮvents dep cted here n are fict t ous No assoc at on w th any rea company, organ zat on, product, doma n name,Į-ma address, ogo, person, p ace, or event s ntended or shou d be nferred Trademarks/EN-US aspx are trademarks of the M crosoft group of compan es A other marks are property of M crosoft and the trademarks sted at http //www m crosoft com/about/ ega /en/us/Inte ectua Property/ Internat ona d rect y at fax (425) 936-7329 V s t our Web s te at www m crosoft com/mspress Send comments to M crosoft Press books are ava ab e through bookse ers and d str butors wor dw de For further nformat onĪbout nternat ona ed t ons, contact your oca M crosoft Corporat on off ce or contact M crosoft Press
Pr nted and bound n the Un ted States of Amer ca L brary of Congress Contro Number 2010934987 Means w thout the wr tten perm ss on of the pub sher A r ghts reserved No part of the contents of th s book may be reproduced or transm tted n any form or by any
0 kommentar(er)
