| タイトル | 平均分散モデルの特徴と不確実性に関する考察: 数理モデルとMicrosoft Excel活用によるデータ分析 |
| その他のタイトル | Characteristics and Uncertainties of Mean-Variance Model: Mathematical Modeling and Data Analysis Using Microsoft Excel |
| 著者（日） | 中西, 真悟 |
| 著者（英） | Nakanishi, Shingo |
| 著者所属（日） | 大阪工業大学 |
| 著者所属（英） | Osaka Institute of Technology |
| 発行日 | 2015-01-10 |
| 発行機関など | 大阪工業大学
Osaka Institute of Technology |
| 刊行物名 | 大阪工業大学紀要
Memoirs of Osaka Institute of Technology |
| 巻 | 59 |
| 号 | 2 |
| 開始ページ | 17 |
| 終了ページ | 46 |
| 刊行年月日 | 2015-01-10 |
| 言語 | jpn
eng |
| 抄録 | We focus on mathematical modeling of mean-variance models in modern portfolio theory for finance. First, we can review mathematical modeling and these characteristics of mean-variance models. Second, we can perform data analysis of the top 10 ratings of Sharpe ratios for 20 years from January 1990 to December 2009. These data in the database shown in a paper titled “Development of local database for obtainable data of stock prices from website and its applications of Mean Variance Model and Capital Asset Pricing Model” has about 470,000 stock closing prices downloaded from Yahoo! Finance Japan. At the same time, we can investigate various characteristics and uncertainties of statistics, time series, and comparisons of both arithmetic mean and logarithmic mean. Furthermore, we can consider the relationship of simultaneous distributions based on mean-variance models. |
| 内容記述 | 形態: カラー図版あり
Physical characteristics: Original contains color illustrations |
| キーワード | 平均分散モデル; 最適ポートフォリオ理論; シャープ・レシオ; 資本市場線; 同時分布; 高次統計量; 時系列解析; Excel統計解析; Mean-Variance Model; Optimal Portfolio Theory; Sharpe Ratio; Capital Market Line (CML); Simultaneous Distribution; High-Order Statistics; Time Series Analysis; Excel Statistical Analysis |
| 資料種別 | Departmental Bulletin Paper |
| NASA分類 | Systems Analysis and Operations Research |
| ISSN | 2188-9007 |
| SHI-NO | AA1540391000 |
| URI | https://repository.exst.jaxa.jp/dspace/handle/a-is/558215 |
