期刊论文

中文

湖南农业大学学报(自然科学版)

1007-1032

1999

25

1

74-77

10.3321/j.issn:1007-1032.1999.01.018

本校为第一机构

提出了在Excel中利用Visual Basic实现多元统计分析的方法,介绍了关键控件与对象的使用,讨论了主成分分析、因子分析、对应分析、系统聚类分析、逐步回归分析、距离判别分析及典型相关分析等多元统计分析函数的语法格式.

In this paper,the method for implementation of multivariate statistical analysis in Excel is presented. Also,the usage of many key controls and objects is introduced. Finally,the grammatical formats are discussed. They include self designed function for principal component analysis,factor analysis,correspondence analysis,cluster analysis,successive regression analysis,distance discriminan...