偏相关与通径分析的EXCEL VBA程序设计

EXCEL VBA programming based on partial correlation and path analysis

EXCEL是国际最流行的电子表格软件,VBA是扩展其功能的最佳工具。用VBA编程语言编制了相关分析、偏相关分析、通径分析与决策系数求算的应用程序,操作简单,结果清晰并且数据录入、结果引用与再加工非常容易。

EXCEL is the international popular electric form software, which function can be extended by VBA optimally. This paper programmed for correlation analysis,partial correlation analysis,path analysis and decision coefficient computing.These programs were easy to operate,and were facilities for inputting data,outputting clear result,citing results and re-processing.