Solving nonlinear problems with local optimal solutions is ...

[haleyc112]

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 2

A variable used to model the effect of categorical independent variables in a regression model which generally takes only the value zero or one is called
 a. a residual. b. the coefficient of determination.
  c. a dummy variable. d. interaction.

[Tonyam972]

Answer to Question 1

c
RATIONALE: Solving nonlinear problems with local optimal solutions is performed using GRG Nonlinear, in Excel Solver, which is based on more classical optimization techniques. Evolutionary Solver may be useful for more complex nonlinear models that involve Excel functions such as VLOOKUP and IF.

Answer to Question 2

c
RATIONALE: A dummy variable is a variable used to model the effect of categorical independent variables in a regression model.