Fundamental IO Analysis of Econ & Mgt
| Numbering Code | P-MGT75 60457 LE44 | Year/Term | 2022 ・ Intensive, First semester | |
|---|---|---|---|---|
| Number of Credits | 2 | Course Type | Lecture | |
| Target Year | Target Student | |||
| Language | Japanese | Day/Period | Intensive | |
| Instructor name |
FUJIKAWA KIYOSHI (Part-time Lecturer) YAMAMOTO TAKASHI (Graduate School of Management Professor) |
|||
| Outline and Purpose of the Course |
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. |
|||
| Course Goals | 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. | |||
| Schedule and Contents |
1. Introduction of Ms-Excel 2. 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 table 8. Leontief inverse matrix and power and sensitivity analysis 9. Equilibrium output determination model 10. Simulation analysis based on equilibrium output determination model 11. Equilibrium price determination model 12. Simulation analysis based on equilibrium price determination model 13. Structural analysis of industry (Skyline analysis, deviation from proportional growth) 14. Interregional and International input output model 15. Application of Input output analysis (Energy and environmental issues, value added deposition) |
|||
| Evaluation Methods and Policy | Performance during the class (50%) and quality of the term report (50%) | |||
| Course Requirements | Participants are required to have basic knowledge on basic economics and mathematics. | |||
| Study outside of Class (preparation and review) | Review after the class, preferably after the class before you seep, is highly recommended. | |||
| Textbooks | Textbooks/References | Lecture materials are distributed to the participants. No specific text book is used. | ||
| References, etc. |
Ronald E. Miller and Peter D. Blair (2009) Input-Output Analysis: Foundations and Extensions Thijs ten Raa (2010) Input-Output Economics: Theory and Application |
|||
