ETX1100/ETX5900 Business Statistics

Week 7: Spreadsheet modelling and optimisation

What you will learn this week

Formulate a spreadsheet model using inputs, decisions, objectives and constraints.
Explore sensitivity using one- and two-way Data Tables.
Work backwards from a target using Goal Seek.
Solve and validate constrained optimisation problems with Solver.

Class workbook

Download the Week 7 modelling workbook and open the interactive slides.

Slides for the week

Upcoming assessments

Week 7: Quiz 7
Week 8: Quiz 8