Author Question: Solving nonlinear problems with local optimal solutions is performed using _____________, in Excel ... (Read 80 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?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

Women are 50% to 75% more likely than men to experience an adverse drug reaction.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

For a complete list of videos, visit our video library