Microsoft Excel 2010
Subtitle: data analysis and business modeling
By: Wayne L. Winston
Publisher: Microsoft Press
Published: 2011
Place of publication: Redmond, Wash
Language: eng
Number of pages: 700
ISBN-13: 9780735643369
Subjects: Statistical methods; Microsoft Excel (Computer file); Industrial management; Decision making; Computer programs
Other titles: Excel 2010 : data analysis and business modeling
Notes: Includes index.
Table of contents: title: What's new in Excel 2010; title: Range names; title: Lookup functions; title: The INDEX function; title: The MATCH function; title: Text functions; title: Dates and date functions; title: Evaluating investments by using net present value criteria; title: Internal rate of return; title: More Excel financial functions; title: Circular references; title: IF statements; title: Time and time functions; title: The paste special command; title: Three-dimensional formulas; title: The auditing tool; title: Sensitivity analysis with data tables; title: The goal seek command; title: Using the scenario manager for sensitivity analysis; title: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; title: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions; title: The OFFSET function; title: The INDIRECT function; title: Conditional formatting; title: Sorting in Excel; title: Tables; title: Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes; title: An introduction to optimization with Excel Solver; title: Using Solver to determine the optimal product mix; title: Using Solver to schedule your workforce; title: Using Solver to solve transportation or distribution problems; title: Using Solver for capital budgeting; title: Using Solver for financial planning; title: Using Solver to rate sports teams; title: Warehouse location and the GRG multistart and Evolutionary Solver engines; title: Penalties and the Evolutionary Solver; title: The traveling salesperson problem; title: Importing data from a text file or document; title: Importing data from the internet; title: Validating data; title: Summarizing data by using histograms; title: Summarizing data by using descriptive statistics; title: Using PivotTables and slicers to describe data; title: Sparklines; title: Summarizing data with database statistical functions; title: Filtering data and removing duplicates; title: Consolidating data; title: Creating subtotals; title: Estimating straight line relationships; title: Modeling exponential growth; title: The power curve; title: Using correlations to summarize relationships; title: Introduction to multiple regression; title: Incorporating qualitative factors into multiple regression; title: Modeling nonlinearities and interactions; title: Analysis of variance: one-way ANOVA; title: Randomized blocks and two-way ANOVA; title: Using moving averages to understand time series; title: Winters's method; title: Ratio-to-moving-average forecast method; title: Forecasting in the presence of special events; title: An introduction to random variables; title: The binomial, hypergeometric, and negative binomial random variables; title: The Poisson and exponential random variable; title: The normal random variable; title: Weibull and beta distributions: modeling machine life and duration of a project; title: Making probability statements from forecasts; title: Using the lognormal random variable to model stock prices; title: Introduction to Monte Carlo simulation; title: Calculating an optimal bid; title: Simulating stock prices and asset allocation modeling; title: Fun and games: simulating gambling and sporting event probabilities; title: Using resampling to analyze data; title: Pricing stock options; title: Determining customer value; title: The economic order quantity inventory model; title: Inventory modeling with uncertain demand; title: Queuing theory: the mathematics of waiting in line; title: Estimating a demand curve; title: Pricing products by using tie-ins; title: Pricing products by using subjectively determined demand; title: Nonlinear pricing; title: Array formulas and functions; title: PowerPivot.