Excel's Scenario Manager allows you to create named scenarios with different values for key variables. These scenarios can be quickly examined and summarized using the What-If Analysis tool.
In this course, you'll use GoalSeek and Solver, both of which are mathematical tools. Goal Seek comes in handy when solving quadratic, cubic, or other equations. Solver is much more powerful and allows complex constrained optimization problems to be easily defined and addressed.
As you'll recognize, Solver's interface, used for specifying objective functions and constraints, is intuitive and easy to use.
Next, you'll use several heavy-duty statistical techniques in Analysis ToolPak. These range from the creation of correlation and covariance matrices, hypothesis testing, and F-test and T-test interpretations to ANOVA, random and periodic sampling, and the construction and analysis of linear regression models.
Objectives |
---|
Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak
|