English   Danish

2017/2018  KAN-CFIVO1001U  Quantitative Methods

English Title
Quantitative Methods

Course information
Language English
Course ECTS 7.5 ECTS
Type Mandatory
Level Full Degree Master
Duration One Semester
Start time of the course Autumn
Timetable Course schedule will be posted at calendar.cbs.dk
Study board
Study Board for MSc in Economics and Business Administration
Course coordinator
  • Peter Raahauge - Department of Finance (FI)
Main academic disciplines
  • Finance
  • Statistics and quantitative methods
Last updated on 30-05-2017

Relevant links
Learning objectives
To achieve the grade 12, students should meet the following learning objectives with no or only minor mistakes or errors: When presented with a problem dealt with in the course, the student should be able to solve the problem using the appropriate software in a way similar to how the problem was solved during the course. When presented with a problem, which is similar but different from the problems dealt with in the course, the student should be able to solve the problem, based on a theoretical understanding of the problems dealt with in the course.
Examination
Quantitative Methods:
Exam ECTS 7,5
Examination form Written sit-in exam on CBS' computers
Individual or group exam Individual exam
Assignment type Written assignment
Duration 4 hours
Grading scale 7-step scale
Examiner(s) One internal examiner
Exam period Autumn
Aids Limited aids, see the list below:
The student is allowed to bring
  • USB key for uploading of notes, books and compendiums in a non-executable format (no applications, application fragments, IT tools etc.)
  • Any calculator
  • Books (including translation dictionaries), compendiums and notes in paper format
The student will have access to
  • Access to CBSLearn
  • Access to the personal drive (S-drive) on CBS´ network
  • Advanced IT application package
At all written sit-in exams the student has access to the basic IT application package (Microsoft Office (minus Excel), digital pen and paper, 7-zip file manager, Adobe Acrobat, Texlive, VLC player, Windows Media Player). PLEASE NOTE: Students are not allowed to communicate with others during the exam : Read more about exam aids and IT application packages here
Make-up exam/re-exam
Same examination form as the ordinary exam
If the number of registered candidates for the make-up examination/re-take examination warrants that it may most appropriately be held as an oral examination, the programme office will inform the students that the make-up examination/re-take examination will be held as an oral examination instead.
Description of the exam procedure

Answers handed in as Excel-file.
 
Course content and structure

The course provides the quantitative tools necessary for following courses like Investments and Empirical Finance successfully.


The course takes a hands-on approach to the material, and a central part of course is worked examples (exercises with guiding solutions), which the students are supposed to implement using appropriate IT-tools like Excel, VBA, and/or R. The course uses a "flipped classroom" approach, see http://en.wikipedia.org/wiki/Flip_teaching: The theoretical foundation for the worked examples is explained using screencasts available on the Internet for viewing on demand. The students work with the worked examples. The scheduled classes are used for personalized guidance with respect to theory and implementation of the worked examples.
 

Theoretical topics covered in the worked examples include:

Analysis: Functions and their properties, Differentiation and Taylor series approximations, Equation solving, Optimization, Integration


Linear Algebra: Vector and matrix algebra, Linear equation systems


Statistics: Random variables and probability distributions, Inference, Hypothesis testing, Regression models, Basic Time Series models, Monte Carlo methods


To the extent the theoretical topics are known from prerequisite courses, the topics will be elaborated (ex: two- or N-dimensional stochastic distributions), addressed in alternative ways (ex: Monte Carlo "proof" of formulas for stochastic variables), and/or used to introduce software functionality.


IT topics covered in the worked examples, to the extend time permits, include:


Excel: Data import and data types, Formulas, references and names, Tables, Graphs, Solver add-in, Data analysis add-in


VBA: Functions, Subs, Local variables, Arrays, For-loops and If-statements, Debugging, Monte Carlo Methods.

 
Teaching methods
Flipped classroom with a mix of traditional lectures, on-line lectures, worked examples (exercises with guiding solutions) and classes with personalized guidance.
Feedback during the teaching period
In addition to the mixed classroom lectures during which the students will have the change to get help and get feedback on their exercises, where will be two voluntary hand-in exercises, similar to the exams, which will include student-to-student (peer-review) feedback based on a guiding solution.
Student workload
On-line lectures 33 hours
Traditional lectures and flipped class-room. 33 hours
Working with worked examples incl. reading 140 hours
Exam 4 hours
Expected literature

Mandatory literature

  • Sydsæter, Hammond, Strøm and Carvajal: Essential Mathematics for Economic Analysis; 5rd ed., 2016, Pearson (or similar).
  • David Skovmand: Supplementary Notes on: Linear Algebra, Probability and Statistics for Empirical Finance, 2013, downloadable.
  • Robert L. McDonald: An Introduction to VBA in Excel, 2000, downloadable.
  • Notes and Worked Examples.


Supplementary literature:

  • Reference books on Excel and VBA. Popular bestsellers like 'Excel 2013 Bible' and 'Excel 2013 Power Programming with VBA' by John Walkenbach are each very extensive (>1000 pages) and available on-line at CBS for free.
  • Selected sections of Financial Markets and Investments, Claus Munk, 2015, downloadable, will help motivating the curriculum.
Last updated on 30-05-2017