When you’re faced with multiple changing variables, however, you must turn to linear and integer programming.
- [Instructor] Goal Seek,…the capability I described in the previous movie,…lets you find answers for problems…that involve changing a single value,…such as the amount of a substance in a mixture.…If you're good at math,…you can solve the type of problem using algebra.…When you're faced with multiple changing variables,…however, you must turn to linear,…nonlinear, and integer programming.…In this movie, I'll describe what those problems look like.…Our goal is to find…optimal solutions to systems of equations.…
If we're using linear programming,…then we can't have any exponents in terms.…For example, the slope of a line…is described using the formula A X plus B,…and that's what we mean by linear.…If you can draw a graph of values,…using a straight line, then it's linear.…Nonlinear programming allows exponents,…and that's where you get curves…and other changes in your lines.…A subtype of this programming is called integer programming,…which requires whole number solutions.…
That might seem like it's easier…than straight up linear or nonlinear programming,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees