| 最优线性回归分析VBA程序设计 |
| |
| 引用本文： | 陈庭木,方兆伟,徐大勇. 最优线性回归分析VBA程序设计[J]. 计算机与农业, 2012, 0(7): 23-26 |
| |
| 作者姓名： | 陈庭木 方兆伟 徐大勇 |
| |
| 作者单位： | 江苏连云港市农科院,江苏连云港222006 |
| |
| 基金项目： | 受连云港市农业攻关计划（编号CGll27）. |
| |
| 摘 要： | 采用成熟多元逐步线性回归算法,设计了基于EXCEL VBA语言的程序,从EXCEL中获取数据,计算完成再将结果输出到EXCEL中,可以简化数据的录入或编辑。
|
| 关 键 词： | 逐步线性回归分析 EXCEL VBA 程序设计 |
Design of VBA Programming with Optimal Linear Regression Analysis |
| |
| CHEN Tingmu,FANG Zhaowei,XU Dayong. Design of VBA Programming with Optimal Linear Regression Analysis[J]. Computer and Agriculture, 2012, 0(7): 23-26 |
| |
| Authors: | CHEN Tingmu FANG Zhaowei XU Dayong |
| |
| Affiliation: | (Agricultural Science Institute of Lianyungang, Jiangsu Lianyungang 222006) |
| |
| Abstract: | In this paper, by the mature algorithm of multiple stepwise linear regression, a program based on EXCEL VBA language was designed to obtain data from the EXCEL, when calculation was done, and the results was outputted to EXCEL, and the data entry or editing was simplified. |
| |
| Keywords: | stepwise linear regression analysis EXCEL VBA programming |
| 本文献已被 维普 等数据库收录！ |
|
