CSE 6040X COMPUTING FOR DATA
ANALYSIS COMPREHENSIVE TEST PAPER
WITH SOLVED QUESTIONS
◉ Differences between Goal Seek and Solver
Answer: Goal Seek only has one output, Solver can have many
Solver can have constraints, Goal Seek has no constraints
Goal Seek can only match goal, Solver can min, max, and match
goal
◉ Solver Techniques
Answer: all can solve linear problems, in order from fastest to
slowest: Simplex, GRG nonlinear,
GRG nonlinear with multiple start points,
Evolutionary
◉ Simplex
Answer: Linear problems only
◉ GRG nonlinear
Answer: Non-linear problems with only one optimum
◉ GRG nonlinear with multiple start points
, Answer: Non-linear with multiple local optima
◉ Evolutionary
Answer: Un-differentiable problems
◉ Access can Input
Answer: Excel, text files
◉ Relationships in Access
Answer: Takes two tables and joining them on a common value
◉ Queries
Answer: Grouping, Criteria, Calculations. Can be on tables,
queries, and tables & queries together
◉ Grouping in Access
Answer: Collapses data
◉ Criteria in Access
Answer: Filters data
◉ Calculations in Access
Answer: Sum, Average, Min, Max
ANALYSIS COMPREHENSIVE TEST PAPER
WITH SOLVED QUESTIONS
◉ Differences between Goal Seek and Solver
Answer: Goal Seek only has one output, Solver can have many
Solver can have constraints, Goal Seek has no constraints
Goal Seek can only match goal, Solver can min, max, and match
goal
◉ Solver Techniques
Answer: all can solve linear problems, in order from fastest to
slowest: Simplex, GRG nonlinear,
GRG nonlinear with multiple start points,
Evolutionary
◉ Simplex
Answer: Linear problems only
◉ GRG nonlinear
Answer: Non-linear problems with only one optimum
◉ GRG nonlinear with multiple start points
, Answer: Non-linear with multiple local optima
◉ Evolutionary
Answer: Un-differentiable problems
◉ Access can Input
Answer: Excel, text files
◉ Relationships in Access
Answer: Takes two tables and joining them on a common value
◉ Queries
Answer: Grouping, Criteria, Calculations. Can be on tables,
queries, and tables & queries together
◉ Grouping in Access
Answer: Collapses data
◉ Criteria in Access
Answer: Filters data
◉ Calculations in Access
Answer: Sum, Average, Min, Max