| 主成分分析法及其EXCEL实现 |
| |
| 引用本文： | 林泽阳.主成分分析法及其EXCEL实现[J].宁波职业技术学院学报,2012(5):24-28. |
| |
| 作者姓名： | 林泽阳 |
| |
| 作者单位： | 上海大学悉尼工商学院 |
| |
| 摘 要： | 主成分分析是一种重要的多元统计分析方法,其广泛应用于自然科学和社会科学的研究中。主成分分析运算过程较复杂,一般需要借助于统计软件来实现。如果手工运算不但计算量大,而且容易出错。文章利用EXCEL中的相关函数,给出了一种实现主成分分析的EXCEL简便算法。
|
| 关 键 词： | 主成分分析 EXCEL 统计软件 |
Principal component analysis & its Excel implementation |
| |
| LIN Ze-yang.Principal component analysis & its Excel implementation[J].Journal of Ningbo Polytechnic,2012(5):24-28. |
| |
| Authors: | LIN Ze-yang |
| |
| Institution: | LIN Ze-yang(Shanghai University,Shanghai 201800,China) |
| |
| Abstract: | The Principal Component Analysis is a vital methodology of multivariate statistical analysis,and is now widely applicated in both natural and social science exploration.The complexity of process is beyond the capacity of manual calculations as it is Large-scale and error-prone,and analysis software is introduced to solve this problem in most circumstance.In this article,a method will be given in Microsoft Excel with the help of its functions. |
| |
| Keywords: | The Principal Component Analysis Excel statistical software |
| 本文献已被 CNKI 维普 等数据库收录！ |
