## 6780000 Fundamental IO Analysis of Econ & Mgt

JA | EN

 科目ナンバリング P-MGT75 60457 LE44 開講年度・開講期 2020・前期集中 単位数 2 単位 授業形態 講義 対象学生 大学院生 使用言語 日本語 曜時限 集中 教員 藤川　清史（非常勤講師） 授業の概要・目的 This course is devoted to learn practical use of MS-Excel as a tool of data processing and to study the input-output analysis with MS-Excel. It course is separated into two parts. The first is for data processing including database handling, pivot table analysis, goal seek function to solve equations, and optimization problem techniques by solver function in MS-Excel. The second part is for input-output analysis including linear algebra mathematics, equilibrium output determination model, equilibrium price determination model, and structural analysis based on input-output tables. 到達目標 As this course is practical application of the input-output theory, the participants of this lecture will be able to understand the structure of the input-output theory and apply the input-output theory for the real input-output tables at the end of the course. 授業計画と内容 1. Introduction of Ms-Excel2. Data handling in Ms-Excel (composite address, vlookup function, pivot table)3. Simulation analysis using Ms-Excel (random number, uniform distribution, normal distribution)4. Optimization problems with Ms-Excel (goal seek, data table, solver)5. Linear algebra (Inverse matrix, simultaneous equation )6. Input output table and system of national account 7. Aggregation of sectors in an input output table8. Leontief inverse matrix and power and sensitivity analysis9. Equilibrium output determination model 10. Simulation analysis based on equilibrium output determination model11. Equilibrium price determination model12. Simulation analysis based on equilibrium price determination model13. Structural analysis of industry (Skyline analysis, deviation from proportional growth)14. Interregional and International input output model15. Application of Input output analysis (Energy and environmental issues, value added deposition) 成績評価の方法・観点 Performance during the class (50%) and quality of the term report (50%) 履修要件 Participants are required to have basic knowledge on basic economics and mathematics. 授業外学習（予習・復習）等 Review after the class, preferably after the class before you seep, is highly recommended. 教科書 Lecture materials are distributed to the participants. No specific text book is used. 参考書等 Ronald E. Miller and Peter D. Blair (2009) Input-Output Analysis: Foundations and Extensions Thijs ten Raa (2010) Input-Output Economics: Theory and Application 