Question 1

If D1 is a data cell,and C1 and C2 are changing cells,then IF(D1 >= 2,C1,C2)is a linear function.

Accepted Answer

A) True 
 B)False

Question 2

In separable programming,each activity that violates the proportionality assumption is separated into parts with a new variable for each part.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following are disadvantages of the Evolutionary Solver?

Accepted Answer

A)  It does not deal well with complicated objective functions.
B)  It does perform well on models with many constraints.
C)  It is easily trapped at local optima.
D)  a and b.
E)  None of the above.F) B) and D)
G) B) and C)

Question 4

A local maximum is always a global maximum in a nonlinear programming problem.

Accepted Answer

A) True 
 B)False

Question 5

Evolutionary Solver is best suited to which kinds of problems?

Accepted Answer

A)  Linear programs.
B)  Nonlinear programs with difficult objective functions.
C)  Nonlinear programs with decreasing marginal returns and no discontinuities.
D)  Nonlinear programs with many constraints.
E)  None of the above.F) C) and E)
G) A) and C)

Question 6

The measure of risk for pairs of stocks in a portfolio selection problem is called:

Accepted Answer

A)  the covariance of the return.
B)  the variance of the return.
C)  the expected return.
D)  decreasing marginal return.
E)  None of the above.F) B) and C)
G) C) and E)

Question 7

Trying different starting points and picking the best solution will always yield the optimal solution to a nonlinear programming problem.

Accepted Answer

A) True 
 B)False

Question 8

Evolutionary Solver is often faster than the standard Solver at solving linear programming problems.

Accepted Answer

A) True 
 B)False

Question 9

The requirement that each term in the objective function only contains a single variable is in a linear program is referred to as:

Accepted Answer

A)  the proportionality assumption.
B)  the divisibility assumption.
C)  the additivity assumption.
D)  a nonlinear function.
E)  None of the above.F) All of the above
G) None of the above

Question 10

Sometimes the Solver can return different solutions when optimizing a nonlinear programming problem.

Accepted Answer

A) True 
 B)False

Question 11

The additivity assumption of linear programming states that each term in the objective function is the sum of two or more variables.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is an example of a nonlinear function?

Accepted Answer

A)  Profit = 5x1 + 7x2 - 2x22.
B)  Profit = 8x1x2 - x12 - 4x22.
C)  Profit = x1 + 6x2 + 3x1x2.
D)  None of the above.
E)  All of the above.F) A) and B)
G) B) and C)

Question 13

When the marginal return from an activity decreases on a continuous basis,the profit graphs will consist of a series of line segments.

Accepted Answer

A) True 
 B)False

Question 14

Evolutionary Solver is based on which of the following concepts?

Accepted Answer

A)  Genetics.
B)  Evolution.
C)  Survival of the Fittest.
D)  All of the above.
E)  b and c only.F) A) and E)
G) B) and D)

Question 15

A quadratic programming problem is a special type of linear programming problem.

Accepted Answer

A) True 
 B)False

Question 16

Nonlinear programming problems with decreasing marginal returns are generally easier to solve then nonlinear programming problems with increasing marginal returns.

Accepted Answer

A) True 
 B)False

Question 17

Excel's curve fitting method is used to graph a nonlinear equation.

Accepted Answer

A) True 
 B)False

Question 18

A linear function may contain which of the following?

Accepted Answer

A)  A term that contains a single variable with an exponent of 1.
B)  A term that contains a single variable with an exponent of 2.
C)  A term that is a constant times the product of two variables.
D)  All of the above.
E)  b.and c.only.F) All of the above
G) C) and D)

Question 19

When there are decreasing marginal returns:

Accepted Answer

A)  the slope of the graph never increases but sometimes decreases.
B)  the slope of the graph never decreases but sometimes increases.
C)  the graph always consists of a smooth curve.
D)  the graph always consists of a series of line segments.
E)  separable programming should not be used.F) C) and D)
G) B) and C)

Question 20

Two runs of the Evolutionary Solver on the same problem will typically yield the same solution.
Multiple Choice Questions

Accepted Answer

A) True 
 B)False

Exam 8: Nonlinear Programming

A linear function may contain which of the following?

Correct AnswerverifiedShow Answer

When the marginal return from an activity decreases on a continuous basis,the profit graphs will consist of a series of line segments.

Correct AnswerverifiedShow Answer

Evolutionary Solver is best suited to which kinds of problems?

Correct AnswerverifiedShow Answer

Excel's curve fitting method is used to graph a nonlinear equation.

Correct AnswerverifiedShow Answer

Which of the following are disadvantages of the Evolutionary Solver?

Correct AnswerverifiedShow Answer

The requirement that each term in the objective function only contains a single variable is in a linear program is referred to as:

Correct AnswerverifiedShow Answer

Nonlinear programming problems with decreasing marginal returns are generally easier to solve then nonlinear programming problems with increasing marginal returns.

Correct AnswerverifiedShow Answer

A local maximum is always a global maximum in a nonlinear programming problem.

Correct AnswerverifiedShow Answer

The measure of risk for pairs of stocks in a portfolio selection problem is called:

Correct AnswerverifiedShow Answer

When there are decreasing marginal returns:

Correct AnswerverifiedShow Answer

A quadratic programming problem is a special type of linear programming problem.

Correct AnswerverifiedShow Answer

Which of the following is an example of a nonlinear function?

Correct AnswerverifiedShow Answer

If D1 is a data cell,and C1 and C2 are changing cells,then IF(D1 >= 2,C1,C2)is a linear function.

Correct AnswerverifiedShow Answer

The additivity assumption of linear programming states that each term in the objective function is the sum of two or more variables.

Correct AnswerverifiedShow Answer

Evolutionary Solver is based on which of the following concepts?

Correct AnswerverifiedShow Answer

Trying different starting points and picking the best solution will always yield the optimal solution to a nonlinear programming problem.

Correct AnswerverifiedShow Answer

Sometimes the Solver can return different solutions when optimizing a nonlinear programming problem.

Correct AnswerverifiedShow Answer

Evolutionary Solver is often faster than the standard Solver at solving linear programming problems.

Correct AnswerverifiedShow Answer

In separable programming,each activity that violates the proportionality assumption is separated into parts with a new variable for each part.

Correct AnswerverifiedShow Answer

Two runs of the Evolutionary Solver on the same problem will typically yield the same solution. Multiple Choice Questions

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified