| Excel在灰色关联分析中的应用 |
| |
| 引用本文： | 刘建,刘丹,刘向远.Excel在灰色关联分析中的应用[J].工业安全与环保,2007,33(7):47-49. |
| |
| 作者姓名： | 刘建 刘丹 刘向远 |
| |
| 作者单位： | 西南交通大学环境科学与工程学院,成都,610031 |
| |
| 基金项目： | 四川省交通厅科学技术研究项目 |
| |
| 摘 要： | 介绍了灰色关联分析的一般步骤,并对其中分辨率的取值和权重的计算作了初步分析.在此基础上,通过将灰色关联分析方法编写成Excel VBA程序,并应用于铜锣山隧道出口端隧道水的来源识别,不仅在较大程度上简化了计算,而且也取得了良好的预期成果.
|
| 关 键 词： | 灰色关联分析 Excel VBA 铜锣山隧道 |
| 修稿时间： | 2006-12-17 |
The Application of Excel in Grey Correlation Analysis |
| |
| LIU Jian,LIU Dan,LIU Xiang-yuan.The Application of Excel in Grey Correlation Analysis[J].Industrial Safety and Dust Control,2007,33(7):47-49. |
| |
| Authors: | LIU Jian LIU Dan LIU Xiang-yuan |
| |
| Institution: | School of Southwest Jiaotong University Chengdu 610031 |
| |
| Abstract: | General steps of grey correlation analysis are introduced in this paper, along with primary analysis on its identification coefficient and weight. Based on this, an Excel VBA program of grey correlation analysis method is designed to be used to identify the source of water in Tongluoshan Tunnel. It not only simplifies the process of calculation to some extent, but also gives an good result. |
| |
| Keywords: | grey correlation analysis Excel VBA tongluoshan tunnel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
