Decision Analysis in Excel (IND520)
Through the use of real world examples, this course provides tools to analyze contemporary business- and microeconomic decision problems and to address uncertainty and competing objectives in decision-making. The decision problems are modelled in Excel to build a solid foundation transferrable to the job market.
Course description for study year 2024-2025. Please note that changes may occur.
Course code
IND520
Version
1
Credits (ECTS)
10
Semester tution start
Spring
Number of semesters
1
Exam semester
Spring
Language of instruction
English
Content
The analysis in this course will be based on different examples of business- and microeconomic decision problems, with focus on developing spreadsheet models that are logically correct and easy to read. The choice of model will be based on the settings of the decision problem at hand. The material starts with simple linear problems and builds up to more complex decision scenarios under uncertainty. The main topics are optimization models, simulation models, decision trees and data analysis.
The course primarily uses Excel, a powerful and commonly used tool in a variety of industries for performing quantitative analysis. Students can work on their own computers with the Excel software (and add-ins) installed. The main Excel add-ins that will be used are Analytic Solver and @RISK (part of DecisionTools Suite). Note that the Analytic Solver add-in does not work optimally on Mac computers, while @RISK is not available for Mac computers. Students who do not have access to an own PC may use one of the UiS (stationary) computers. Some course material will be covered in pre-recorded lectures as foundation for in-person lectures. Lecture recordings will be made available to students after each class, unless otherwise specified.
The course includes presentations by industry practitioners on how they use Excel in decision making at their institutions. Students will have the opportunity to ask questions and interact with the industry representatives.
Learning outcome
Knowledge
After completing the course, the students will know:
- linear, integer and non-linear mathematical programming relevant to business decision problems
- conditions under which different models can be used and their limitations
- solution algorithms
- analysis of decisions under uncertainty
- simulation analysis
Skills
After completing the course, the student will be able to:
- set up a spreadsheet model of a business decision problem in Excel
- determine when to use LP models, integer models or non-linear models
- perform sensitivity analysis for LP problems
- read and interpret sensitivity reports for LP problems, including shadow prices and slack values
- solve for the problem's optimal solution in Excel
- analyze decision trees for decision problems under uncertainty
- compute the value of different degrees of information based on expected value as decision criteria
- perform basic simulation models in Excel to evaluate the consequences of decisions under uncertainty
- compute and interpret confidence intervals for estimates from simulation models
- provide economic interpretations of the model solutions and what they imply for the costs and constraints facing businesses in decision problems
General competence
After completing the course, the student will be able to communicate with industry representatives on:
- how a business decision problem can be formulated as a mathematical decision problem
- the different types of models available and the conditions under which they apply
- how the models can be practically implemented and solved
- the fundamental economic constraints and trade-offs businesses face in their decision problems
Required prerequisite knowledge
Recommended prerequisites
Exam
Folder
Form of assessment | Weight | Duration | Marks | Aid |
---|---|---|---|---|
Folder | 1/1 | 1 Semesters | Letter grades |
This portfolio assessment includes the following activities with weights indicated in parentheses:
• 5 individual in-class quizzes (2% each, for a total of 10% of portfolio assessment)
• 1 individual take-home assignment (30%)
• 1 group presentation flipped-classroom style with peer-review (30%)
• 1 group project where students will clean and prepare data, and analyze it using Excel - delivered as written report (30%)
This assessment plan also applies to students who want to improve their result in the course.Retake options are not available for this portfolio assessment. Students who do not pass may undertake the portfolio assessment again the next time the course is taught.
Coursework requirements
Course teacher(s)
Course coordinator:
Andreea-Laura CojocaruCourse teacher:
Andreea-Laura CojocaruHead of Department:
Tore MarkesetMethod of work
Overlapping courses
Course | Reduction (SP) |
---|---|
Decision analysis with Excel (MIN240_1) | 10 |