
Ratio-to-moving-average forecast methodĬhapter 65. Using moving averages to understand time seriesĬhapter 64. Randomized blocks and two-way ANOVAĬhapter 62. Analysis of variance: one-way ANOVAĬhapter 61. Modeling nonlinearities and interactionsĬhapter 60. Incorporating qualitative factors into multiple regressionĬhapter 59. Introduction to multiple regressionĬhapter 58. Using correlations to summarize relationshipsĬhapter 57. Estimating straight-line relationshipsĬhapter 56. Filtering data and removing duplicatesĬhapter 53. Summarizing data with database statistical functionsĬhapter 49. Using PivotTables and slicers to describe dataĬhapter 48. Summarizing data by using descriptive statisticsĬhapter 43. Summarizing data by using histogramsĬhapter 42. Importing data from the InternetĬhapter 41. Importing data from a text file or documentĬhapter 39. The traveling salesperson problemĬhapter 38. Penalties and the Evolutionary SolverĬhapter 37. Warehouse location and the GRG Multistart and Evolutionary Solver enginesĬhapter 36. Using Solver to rate sports teamsĬhapter 35. Using Solver for financial planningĬhapter 34. Using Solver for capital budgetingĬhapter 33. Using Solver to solve transportation or distribution problemsĬhapter 32. Using Solver to schedule your workforceĬhapter 31. Using Solver to determine the optimal product mixĬhapter 30. Introducing optimization with Excel SolverĬhapter 29. Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxesĬhapter 28. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functionsĬhapter 26.

The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functionsĬhapter 20. Using the Scenario Manager for sensitivity analysisĬhapter 19. Sensitivity analysis with data tablesĬhapter 18. The Auditing tool and Inquire add-inĬhapter 16. More Excel financial functionsĬhapter 15. Evaluating investments by using net present value criteriaĬhapter 9. Apply important modeling tools such as the Inquire add-inĬhapter 7.Run Monte Carlo simulations on stock prices and bidding models.Tame complex optimization problems with Excel Solver.Make your charts more effective with the Power View tool.Delve into key financial, statistical, and time functions.Master advanced Excel functions such as OFFSET and INDIRECT.Use Excel Trend Curves, multiple regression, and exponential smoothing.


Data analysis regression excel 2013 how to#
Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables-and how to effectively build a relational data source inside an Excel workbook. Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results.
