![]() In Excel, you can use Solver to find an optimal value (maximum or minimum, or a certain value) for a formula in one cell called the objective cell, subject to certain constraints or limits, on the values of other formula cells on the worksheet. ![]() Then, one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, under certain constraints. Solver is a Microsoft Excel add-in program you can use for optimization in what-if analysis.Īccording to O'Brien and Marakas, optimization analysis is a more complex extension of goal-seeking analysis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |