Author Question: Solving nonlinear problems with local optimal solutions is performed using _____________, in Excel ... (Read 81 times)

haleyc112

  • Hero Member
  • *****
  • Posts: 600
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

  • Sr. Member
  • ****
  • Posts: 342
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.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

For a complete list of videos, visit our video library