| 回 | 項目 | 内容 |
| 第1回 | Course introduction | Understanding an overview of this lecture, guidance and description of the detail of the course |
| 第2回 | Collecting and processing data with Excel 1 | Review of data analysis tools in Excel for basic statistical and economic analysis |
| 第3回 | Collecting and processing data with Excel 2 (Time-series data) | Gathering time-series data from the internet, processing, creating graphs, and conducting initial analysis |
| 第4回 | Collecting and processing data with Excel 3 (Cross-sectional data) | Gathering cross-sectional data from the internet, processing, creating graphs, and conducting initial analysis |
| 第5回 | Collecting and processing data with Excel 4 (Various data) | Gathering different data types from the internet (financial, public, labor, trade data), creating graphs, and conducting initial analysis |
| 第6回 | Theoretical model and statistical analysis | Understanding the concept of statistics and theoretical economic model for analysis and further studies |
| 第7回 | Related statistics | Description of the concept of correlation coefficient and properties of statistical inference for regression model |
| 第8回 | Relationship between two variables – Correlation coefficient | Understanding the relationship between two variables and calculation of correlation coefficient by using Excel |
| 第9回 | Simple regression model | Understanding simple regression analysis and using Excel to determine least squares estimates |
| 第10回 | Multiple regression model | Understanding multiple regression analysis and using Excel to determine least squares estimates |
| 第11回 | Data Processing - Multiple regression analysis and variable transformation | Understanding the concept of variable transformation in regression analysis and how to interpret estimation from transformed variables |
| 第12回 | Application and practical data analysis 1 | Performing practical analysis from actual data and interpreting the output of regression model involving given topics |
| 第13回 | Application and practical data analysis 2 | Choosing your own data to design and perform basic economic analysis, and interpret estimated results |
| 第14回 | Final review and practice | Submission 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 |
| 第15回 | Summary | Questions 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 |
