| Excel软件中"回归分析工具"应用拓宽 |
| |
| 引用本文： | 包凤达. Excel软件中"回归分析工具"应用拓宽[J]. 上海应用技术学院学报：自然科学版, 2002, 2(1): 46-49 |
| |
| 作者姓名： | 包凤达 |
| |
| 作者单位： | 上海应用技术学院经济与管理工程系 上海,200235 |
| |
| 摘 要： | Excel软件中“回归”分析工具仅适用于多元线性方程的拟合。提出自 回归、加权线性回归模型以及非线性方程的转化和化一元高次方程为多元线性方程,并利用“回归”分析工具求解, 拓宽了“回归”分析工具的应用。
|
| 关 键 词： | Excel软件 “回归分析工具” “回归”分析软件 非线性方程 一元线性自回归 加权线性回归 |
| 文章编号： | 1671-7333(2002)01-0046-04 |
| 修稿时间： | 2000-12-21 |
The Broadening of Application of the Regression Analysis Tool in Excel Software |
| |
| BAO Feng-da. The Broadening of Application of the Regression Analysis Tool in Excel Software[J]. Journal of Shanghai Institute of Technology: Natural Science, 2002, 2(1): 46-49 |
| |
| Authors: | BAO Feng-da |
| |
| Abstract: | The regression analysis tool in Excel software is applied only to the fitting of linear equation.This paper puts forward "self-regression"weighted linear regression",method of non-linear equation's change into linear and simple high power equation's change into multiple linear equation.So, we can use the regression analysis tool to resolve many non-linear problems and broaden application of the regression analysis tool. |
| |
| Keywords: | regression analysis softweare non-linear equation broaden application |
| 本文献已被 CNKI 维普 等数据库收录！ |
