國立台灣大學    National Taiwan University      國際企業學系    Department of International Business


Quantitative Methods For Decision Making (undergraduate level)

 
File Name Description
202209 Quantitative Methods for Decision Making_Syllabus.pdf Syllabus of Quantitative Methods for Decision Making
QMFDM_Ch01.pptx Systems of Linear Equations
QMFDM_Ch02.pptx Matrices
QMFDM_Ch03.pptx Determinants
QMFDM_Ch04.pptx Vector Spaces
QMFDM_Ch05.pptx Inner Product Spaces
QMFDM_Ch06.pptx Linear Transformations
QMFDM_Ch07.pptx Eigenvalues and Eigenvectors
QMFDM_Ch09.pptx Linear Programming
Ch09_Text_Book.pdf Electronic Text File for Chapter 9
Ch09_Answer_Key_odd.pdf Brief Solution for the Odd-Numbered Exercises in Chapter 9
Applications in Ch1.pdf Scanned Copy of the Application Section in Chapter 1
Applications in Ch2.pdf Scanned Copy of the Application Section in Chapter 2
Applications in Ch3.pdf Scanned Copy of the Application Section in Chapter 3
Applications in Ch4.pdf Scanned Copy of the Application Section in Chapter 4
Applications in Ch5.pdf Scanned Copy of the Application Section in Chapter 5
Applications in Ch6.pdf Scanned Copy of the Application Section in Chapter 6
Applications in Ch7.pdf Scanned Copy of the Application Section in Chapter 7
Homework3_CAPM.xlsx Excel file for Homework 3
Homework4_Portfolio_Frontier.xlsm Excel file for Homework 4
PINV_D_P = D.xlsx Numerical Verification that P^INV*D*P=D
Example 10  for regression in Ch 2.xlsx Example for Linear Regression in Chapter 2
Matrix operations in Excel for Ch 2.xlsx Introduction of Some Matrix Operations in Excel
VBA Introduction.pptx Introduction of VBA
Array, String, and Number.xlsm Introduction of VBA
Call functions provided by Excel.xlsm Introduction of VBA
Macro in Module.xlsm Introduction of VBA
CommandButton and Checkbox.xlsm Introduction of VBA
For and Do While.xlsm Introduction of VBA
Project and Module.xlsm Introduction of VBA
Function or Sub.xlsm Introduction of VBA
GoTo and Exit.xlsm Introduction of VBA
User-Defined RMSE function.xlsm Introduction of VBA
Matrix Addition (use mouse to select input cells).xlsm Introduction of VBA
Matrix Multiplication (call Excel function MMULT).xlsm Introduction of VBA
Interchange two rows.xlsm Introduction of VBA
Excel VBA (Office 2019) for Mac-Note 1.pdf Introduction of VBA
Excel VBA (Office 2019) for Mac-Note 2.pdf Introduction of VBA
Monte Carlo Simulation.pptx Introduction of the Monte Carlo Simulation
Count.xlsm Introduction of the Monte Carlo Simulation
Contract pricing with MCS.xlsx Introduction of the Monte Carlo Simulation
Standard Error.xlsx Introduction of the Monte Carlo Simulation
Effect of Antithetic.xlsx Introduction of the Monte Carlo Simulation
MCS applications.xlsx Introduction of the Monte Carlo Simulation