![]() Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. Pricing products by using subjectively determined demand. Queuing theory: the mathematics of waiting in line. Inventory modeling with uncertain demand. The economic order quantity inventory model. Fun and games: simulating gambling and sporting event probabilities. Simulating stock prices and asset allocation modeling. Using the lognormal random variable to model stock prices. ![]() Making probability statements from forecasts. Weibull and beta distributions: modeling machine life and duration of a project. The Poisson and exponential random variable. The binomial, hypergeometric, and negative binomial random variables. Forecasting in the presence of special events. ![]() Using moving averages to understand time series. Modeling nonlinearities and interactions. Incorporating qualitative factors into multiple regression. Using correlations to summarize relationships. Summarizing data with database statistical functions. Using PivotTables and slicers to describe data. Summarizing data by using descriptive statistics. Importing data from a text file or document. Warehouse location and the GRG Multistart and Evolutionary Solver engines. ![]() Using Solver to solve transportation or distribution problems. ![]() Using Solver to determine the optimal product. Introducing optimization with Excel Solver. boxes, combo boxes, and group list boxes. Spinner buttons, scroll bars, option buttons, check. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions. Using the Scenario Manager for sensitivity analysis The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions. Evaluating investments by using net present value criteria. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |