From the course: Excel: Using Solver for Decision Analysis

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Introduce linear, nonlinear, and evolutionary programming

Introduce linear, nonlinear, and evolutionary programming - Microsoft Excel Tutorial

From the course: Excel: Using Solver for Decision Analysis

Start my 1-month free trial Buy for my team

Introduce linear, nonlinear, and evolutionary programming

“

- [Instructor] Before I get into using Solver, I would like to give you an introduction to linear and integer programming. The goal in both cases is to find the optimal solution to a system of equations. Within those equations, which we'll look at examples in a moment, linear programming does not allow exponents or things like division or counting. You can only have multiplication, addition, and subtraction. Non-linear programming does allow exponents and division and so on. But where linear programming will find you an optimal solution, if there is one, non-linear programming does not guarantee that. And, finally, integer programming requires whole number solutions. For example, you couldn't sell one half of a car to someone. You can only sell cars as entire units. Now let's take a look at what I mean by systems of equations. These are mathematical representations of the constraints on a problem. For example, if you…

Contents