Based on EXCEL Macro to Realize Comprehensive Evaluation by Principal Component Analysis with One-Key

摘要

Aiming at the shortcoming that obtained from comprehensive evaluation by principal component analysis, this paper points out the method of based on the EXCEL/VBA one-click technology to achieve principal component comprehensive evaluation. Namely, according to the algorithm of Eigenvalue and Eigenvector with the function in Excel-macro, in this article, an easy-to-implement solution to comprehensive evaluation by principal component analysis with VBA in Microsoft EXCEL is provided, which makes users be completely free from manual operation. It is raising the comprehensive evaluation by principal component analysis method practical. And besides, it analyses an example with the method and gets better effects.