授業の目的 【日本語】
Goals of the Course(JPN) | | | Ms-Excelを用いて，データハンドリングの基礎，専門的な関数の使い方(財務関数，行列関数等)，最適問題の解法，産業連関分析の基礎，数理統計学の基礎，回帰分析の基礎を学ぶ．単にソフトウェアの使い方を知るだけではなく，その数学的な背景も同時に理解するのが本講義の目的です． |
|
|
授業の目的 【英語】
Goals of the Course | | | Students will learn the fundamentals of data handling, the use of specialized functions (financial functions, matrix functions, tec.), methods for solving optimization problems, and the basics of input-output analysis, mathematical statistics, and regression analysis using MS-Excel, . The objective of this course is not merely to learn how to use the software, but also to understand the underlying mathematical principles. |
|
|
到達目標 【日本語】
Objectives of the Course(JPN) | | | 既に述べたように，Ms-Excelを用いて，データ処理の基礎，専門的な関数の使い方(財務関数，行列関数等)，最適問題の解法，産業連関分析の基礎，数理統計学の基礎，回帰分析の基礎を身に着けることが本講義の到達目標です．これまでは解法の手掛かりすら分からなかったことについて，少なくとも解法の道筋が見えるようになれば目標達成です，これは問題の解法の数学的な背景も理解するということとほとんど同じことです． |
|
|
授業の内容や構成
Course Content / Plan | | 01 Warming-up for Data Analysis with Excel
02 Introduction to Data Handling
03 Data Aggregation and Integration (Data Menu and Pivot Table)
04 Practical Excel Data Handling
05 Solving Optimization Problems 1 (Goal Seek)
06 Solving Optimization Problems 2 (Solver)
07 Vector and Matrix Calculations
08 Fundamentals of Input-Output Analysis
09 Applications of Input-Output Analysis
10 Introduction to Mathematical Statistics
11 Interval Estimation and Hypothesis Testing for Means 1
12 Interval Estimation and Hypothesis Testing for Means 2
13 Testing Differences in Means and Goodness-of-Fit Tests
14 Introduction to Regression Analysis (Application of Mean Estimation)
15 Interpretion of Regression Analysis (Application of Testing Mean Estimates) |
|
|
履修条件・関連する科目
Course Prerequisites and Related Courses | | | There are no specific prerequisites for taking this course．However, students are required to have basic knowledge of mathematics and Excel operations. |
|
|
成績評価の方法と基準
Course Evaluation Method and Criteria | | | The primary requirement is attendance at the lectures; course credit will not be granted for unexcused absences. Grades will be determined based on a report submitted at the end of the term. However, since the content of the report corresponds to the lecture material, attending the lectures will naturally enable you to complete and submit the report. |
|
|
教科書・参考書
Textbook/Reference Book | | | There is no designated textbook. Lecture materials will be provided, so students are required to download them. Reference books will be introduced as appropriate. |
|
|
課外学習等（授業時間外学習の指示）
Study Load(Self-directed Learning Outside Course Hours) | | | It is often said that humans are able to go on living because they can forget things. However, forgetting the content of a lecture is a waste of both time and tuition money. Please review the material covered in class several times on the very day the lecture takes place. It may seem like a trivial matter, but the results will become apparent much later on. |
|
|
注意事項
Notice for Students | | | As this course involves the use of MS-Excel, please bring a PC and a mouse to every class; a mouse is mandatory. Lecture materials will be made available online, so please download them in advance. |
|
|
授業開講形態等
Lecture format, etc. | | | As mentioned in the previous section, since this course involves lectures using MS-Excel, please bring a PC and a mouse to every class; a mouse is mandatory. Lecture materials will be made available online, so please download them in advance. |
|
|
遠隔授業（オンデマンド型）で行う場合の追加措置
Additional measures for remote class (on-demand class) | | | The lecture will be held in person. |
|
|
質問への対応方法
Office hour | | | As I am a part-time lecturer, I am not based at Nagoya University. I accept questions via email; the email address will be provided during the lecture. If a question involves complex details that cannot be addressed via email, I can arrange a time to meet with you if you make an appointment. |
|
|