Solving nonlinear problems with local optimal solutions is performed using _____________, in Excel ...

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

Q. 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.

Q. 3

The __________ option in Excel Solver is helpful when the solution to a problem appears to depend on the starting values for the decision variables.
 a. Restart
  b. Convergence
  c. Derivatives
  d. Multistart

Q. 4

________________ is used to test the hypothesis that the values of the regression parameters B0, B1, B2, ... Bq are all zero.
 a. An F test b. A t test
  c. The least squares method d. Extrapolation

Q. 5

A function that is bowl-shaped up is called a(n) _________ function.
 a. concave
  b. optimal
  c. convex
  d. elliptical

Q. 6

The degree of correlation among independent variables in a regression model is called
 a. multicollinearity. b. interaction.
  c. the coefficient of determination. d. the sum of squared errors (SSE).