LINEAR ALGEBRA AND OPTIMIZATION FOR MACHINE LEARNING ACTUAL TEST QUESTIONS AND SOLUTIONS COMPREHENSIVE REVIEW PACKAGE

LINEAR ALGEBRA AND OPTIMIZATION
FOR MACHINE LEARNING ACTUAL TEST
QUESTIONS AND SOLUTIONS
COMPREHENSIVE REVIEW PACKAGE

●● What is the MOST important tool in prescriptive analytics?
Answer: Optimization


●● What is the quantity that an optimization model seeks to maximize or
minimize?
Answer: Objective function


●● What are decision variables in an optimization model?
Answer: Unknown values the model seeks to determine


●● How are constraints best described?
Answer: Limitations, requirements, or restrictions imposed on a solution


●● Which Excel function is RECOMMENDED when building linear
optimization models?
Answer: SUMPRODUCT

, ●● Which Excel functions should be AVOIDED in linear optimization
models?
Answer: IF


●● What is a feasible solution to an optimization problem?
Answer: One that satisfies all of the constraints


●● What does the Solver Answer Report provide?
Answer: Basic info including original and optimal objective and
decision variable values


●● What is a binding constraint?
Answer: One where the Cell Value equals the right-hand side of the
constraint


●● Which Solver message indicates an infeasible problem?
Answer: Solver could not find a feasible solution


●● What does an unbounded solution mean?
Answer: The objective can be increased or decreased without bound


●● When do alternative optimal solutions exist?