EXCEL和VBA金融建模.pdf

《EXCEL和VBA金融建模.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、目录前言............................................................................................6致谢............................................................................................7第1章介绍..........................................................................

2、....81.1金融学概览........................................................................................................................81.2收益分布假设....................................................................................................................91.3数学和统计方法.

3、...............................................................................................................91.4数值方法............................................................................................................................91.5Excel解决方案...............

4、...................................................................................................91.6本书主题..........................................................................................................................101.7有关Excel工作簿...........................

5、..................................................................................111.8意见和建议......................................................................................................................11第2章高级Excel函数和过程............................................

6、...122.1访问Excel函数.................................................................................................................122.2数学类函数......................................................................................................................132.3统计类函数...

7、...................................................................................................................142.3.1使用频率函数Frequency......................................................................................152.3.2使用分位数函数Quartile..........................

8、............................................................182.3.3使用正态函数Norm..........................