Solving nonlinear problems with local optimal solutions is performed using _____________, in Excel Solver, which is based on more classical optimization techniques.
A)Goal Seeker
B)Linear Regression
C)GRG Nonlinear
D)Simplex LP

Question

Quizplus · Accepted Answer

Excel Solver's GRG Nonlinear method is designed for solving nonlinear problems with local optimal solutions. It uses Generalized Reduced Gradient (GRG) algorithm which is a well-established optimization technique for non-linear problems. Therefore, the best choice in this scenario would be C - GRG Nonlinear.

Solving Nonlinear Problems with Local Optimal Solutions Is Performed Using