Question 1

The Nonlinear Solver keeps track of a large set of candidate solutions,called the population

Accepted Answer

A) True 
 B)False

Question 2

If C1:C6 are all changing cells,then SUMPRODUCT(C1:C3,C4:C6)is a linear function

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Excel's curve fitting method is used to find the values of the parameters for an equation that best fit data

Accepted Answer

A) True 
 B)False

Question 6

If the data cells are in column D and the changing cells are in column C,which of the following are not linear formulas in a spreadsheet?

Accepted Answer

A) IF(D1 >= 6,C1,C2) 
B) ROUND(C3) 
C) ABS(C3) 
D) All of the above 
E) b and c only 
A) IF(D1 >= 6,C1,C2) 
B) ROUND(C3) 
C) ABS(C3) 
D) All of the above 
E) b and c only

Question 7

If a model uses IF or ROUND functions that incorporate the changing cells,then running the RSPE Analyze Model without Solving feature will typically say the model is of what type?

Accepted Answer

A) Linear 
B) NLP Convex 
C) QP Convex 
D) NSP 
E) None of the above 
A) Linear 
B) NLP Convex 
C) QP Convex 
D) NSP 
E) None of the above

Question 8

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 
A) Genetics 
B) Evolution 
C) Survival of the Fittest 
D) All of the above 
E) b and c only

Question 9

When applying nonlinear programming to portfolio selection,a trade-off is being made between the expected return and the risk associated with the investment

Accepted Answer

A) True 
 B)False

Question 10

The additivity assumption can be violated by nonlinear programming because of cross-product terms involving the product of two variables

Accepted Answer

A) True 
 B)False

Question 11

It now is common practice for professional managers of large stock portfolios to use computer models based partially on separable programming

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

The Nonlinear Solver keeps track of a large set of candidate solutions,called the population

If C1:C6 are all changing cells,then SUMPRODUCT(C1:C3,C4:C6)is a linear function

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

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

Excel's curve fitting method is used to find the values of the parameters for an equation that best fit data

If the data cells are in column D and the changing cells are in column C,which of the following are not linear formulas in a spreadsheet?

If a model uses IF or ROUND functions that incorporate the changing cells,then running the RSPE Analyze Model without Solving feature will typically say the model is of what type?

Evolutionary Solver is based on which of the following concepts?

When applying nonlinear programming to portfolio selection,a trade-off is being made between the expected return and the risk associated with the investment

The additivity assumption can be violated by nonlinear programming because of cross-product terms involving the product of two variables

It now is common practice for professional managers of large stock portfolios to use computer models based partially on separable programming

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

Introduction

Linear programming: Basic Concepts

Linear programming: Formulation and applications

Theart of modeling with spread sheets

What-If Analysis for linear programming

Network optimization problems

Using binary integer programming to deal withy es-Or-No decisions

Decision Analysis

Forecasting

Queuing models

Computer simulation: Basic Concepts

Computer simulation with risks olver platform

Solution concepts for linear programming

Transportation and assignment problems

Pert CPM models for project management

Goal programming

Inventory management with known demand

Inventory management with uncertain demand

Computer simulation with crystal ball

Filters

Exam 8: Non linear programming

The Nonlinear Solver keeps track of a large set of candidate solutions,called the population

If C1:C6 are all changing cells,then SUMPRODUCT(C1:C3,C4:C6)is a linear function

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

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

Excel's curve fitting method is used to find the values of the parameters for an equation that best fit data

If the data cells are in column D and the changing cells are in column C,which of the following are not linear formulas in a spreadsheet?

If a model uses IF or ROUND functions that incorporate the changing cells,then running the RSPE Analyze Model without Solving feature will typically say the model is of what type?

Evolutionary Solver is based on which of the following concepts?

When applying nonlinear programming to portfolio selection,a trade-off is being made between the expected return and the risk associated with the investment

The additivity assumption can be violated by nonlinear programming because of cross-product terms involving the product of two variables

It now is common practice for professional managers of large stock portfolios to use computer models based partially on separable programming

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

Introduction

Linear programming: Basic Concepts

Linear programming: Formulation and applications

Theart of modeling with spread sheets

What-If Analysis for linear programming

Network optimization problems

Using binary integer programming to deal withy es-Or-No decisions

Decision Analysis

Forecasting

Queuing models

Computer simulation: Basic Concepts

Computer simulation with risks olver platform

Solution concepts for linear programming

Transportation and assignment problems

Pert CPM models for project management

Goal programming

Inventory management with known demand

Inventory management with uncertain demand

Computer simulation with crystal ball

Filters