講義名 経済特殊講義Ⅲ（EmpiricalAnalysis Method（英））　≪□第一部≫
講義開講時期 前期
曜日･時限 月５
単位数 2

担当教員
氏名
土屋　陽一

学習目標(到達目標) This course is designed for students who desire to gain skills to handle data using Microsoft Excel. Students will be able to combine basic economic concept and statistical inference methods to estimate the relationship among economic variables using ordinary least squares estimation in Excel.
授業概要(教育目的) In this course, emphasis is placed on the application of linear regression, the use of Excel for statistical analysis, and its data analysis tools for further studies.
授業計画表
 
回項目内容
第1回Course introductionUnderstanding an overview of this lecture, guidance and description of the detail of the course
[Preparation] Not required.
第2回What is empirical analysis?―Econometrics, economic theory, and economic statisticsUnderstanding empirical analysis, econometrics, economic theory, and economic statistics
[Preparation] Reading the uploaded PPT slides.
第3回Data structure and drawing graphs and figuresUnderstanding data structure used in Economics and creating graphs
[Preparation] Reading the uploaded PPT slides.
第4回Basics in statisticsUnderstanding descriptive statistics including mean, median, and standard deviation. Their calculation with Excel.
[Preparation] Reading the uploaded PPT slides.
第5回Basics in probabilityUnderstanding concepts, definitions, and basic properties of probability.
[Preparation] Reading the uploaded PPT slides.
第6回Review and exercisesReview and in-class-report. The report covers the classes 1 through 5.
[Preparation] Review the previous classes.
第7回Relationship between two variables―Correlation coefficientUnderstanding the relationship between two variables and calculation of correlation coefficient by using Excel.
[Preparation] Reading the uploaded PPT slides.
第8回Introduction to simple regression modelIntroduction of simple regression model. Understanding simple regression analysis and concepts of ordinary least squares.
[Preparation] Reading the uploaded PPT slides.
第9回Simple regression model 1Understanding simple regression analysis and using Excel to determine least squares estimates
[Preparation] Reading the uploaded PPT slides.
第10回Simple regression model 2Understanding estimation and inference in simple regression analysis.
[Preparation] Reading the uploaded PPT slides.
第11回Introduction to multiple regression modelIntroduction of multiple regression model. Understanding multiple regression analysis and using Excel to determine least squares estimates.
[Preparation] Reading the uploaded PPT slides.
第12回Multiple regression model: irrelevant and omitted variablesUnderstanding crucial issues (inclusion of irrelevant and omitted variables) on multiple regression model.

[Preparation] Reading the uploaded PPT slides.
第13回Multiple regression model: multi-collinearity and dummy variablesUnderstanding crucial issues (multi-collinearity and dummy variables) on multiple regression model.
[Preparation] Reading the uploaded PPT slides.
第14回Final review and practiceSubmission of final report; students are expected to be able to process actual data, generate basic statistics from a given data set, and provide basic interpretation that makes statistical and economic sense
[Preparation] Reading the uploaded PPT slides.
第15回SummaryQuestions and answers; summarize the content of the course to increase students’ awareness and capability to use various tools available in Excel to process and analyze actual data based on economic concept
[Preparation] Reading the uploaded PPT slides.
授業形式 The course is taught through short lectures, student presentations, and classroom discussions.
評価方法
定期試験 レポート 小テスト 講義態度
（出席） 		その他 合計
0% 50% 0% 50% 0% 100%
テキスト No required or specific textbooks.
参考文献 縄田和満『Excelによる統計入門―Excel2007対応版―』朝倉書店
白砂堤津耶『例題で学ぶ初歩からの計量経済学(第2版)』日本評論社
梅田雅信・宇都宮浄人『経済統計の活用と論点(第3版)』東洋経済新報社
事前学習の内容など，学生へのメッセージ The core of this course lies on the corresponding empirical applications using Excel. As a result, experience with basic computer commands is recommended and experience with Excel is preferred but not required.