Hold Ctrl-tasten nede. Trykk på + for å forstørre eller - for å forminske.


Decision analysis using Excel

This is the study programme for 2020/2021.

The course uses Excel to analyse different buisness- and microeconomic decision problems. The course focuses on analyzing real world examples to show how to solve relevant economic decision problems using Excel.

Learning outcome

On successful completion of this module, students should be able to: * Develop spreadsheet models for quantitative analysis of decision problems - optimisation and simulation. * Interpret results from quantitative analysis. * Sensitivity Analysis. * Use Excel


The course uses the spreadsheet program Excel, a powerful and useful tool for quantitative analysis. We analyze different examples of firm- and microeconomic decision problems. Focus will be on develping spreadsheet models which are both logically corret and easy to read, in addition to sensitivity analysis. Mathematical methods for problem solving will not be part of the course. The main subjects are optimization models, simulation models, decision trees and data analysis.
The lectures are streamed and available online. Access will be given to university computers at specified computer rooms. The course allows students to use their own computers with the Excel software (add-ins) used in the course. This software is available by purchasing a new course textbook. The software does not work on mac computers, and to practice and follow the lectures with your own computer you need a pc with Windows operating system. If you do not have access to this, you have to use one of the school (stationary) computers.

Required prerequisite knowledge


Recommended previous knowledge

Basic knowledge in business economics, mathematics, micro-economics, statistics and use of spreadsheet


Weight Duration Marks Aid
Home exam1/13 daysA - FAll.

Coursework requirements

Mandatory assignments
Two mandatory assignments during the semester. Must be passed in order to take the exam. Can be done in groups of up to four people.

Course teacher(s)

Course coordinator
Atle Øglend
Course teacher
Lars Christian Bruno
Head of Department
Tore Markeset

Method of work

Normally four hours lectures/problem solving on pc per week. Lectures will be given in English. Student will follow the lectures using their own laptops (not mac), or using the university computers.

Overlapping courses

Course Reduction (SP)
Decision analysis with Excel (MIN240_1) 10

Open to

Master in Industrial Economics and master in Business and Administration at the UiS Business School

Course assessment

Form and/or discussion


Literatur will be published as soon as it has been prepared by the course coordinator/teacher

This is the study programme for 2020/2021.

Sist oppdatert: 15.08.2020