| Excel回归分析解多元线性方程 |
| |
| 引用本文： | 开小明,;包翠莲.Excel回归分析解多元线性方程[J].光谱实验室,2014(6):727-729. |
| |
| 作者姓名： | 开小明 ;包翠莲 |
| |
| 作者单位： | [1]安庆师范学院化学化工学院,安徽省安庆市菱湖南路128号246011; [2]安庆职业技术学院公共基础部,安徽省安庆市天柱山东路99号246003 |
| |
| 摘 要： | 介绍了回归分析计算原理，LINEST（known_y’s，known_x’s，const，stats）语法。通过补加一组方程，Excel回归分析可解多元线性方程，列举了解多元线性方程实例。
|
| 关 键 词： | 回归分析 多元线性方程 LINEST函数 数据分析 Excel |
Regression Solution a Multiple Linearity Equation by Excel |
| |
| Institution: | KAI Xiao-Ming ,BAO Cui-Lian (1School of Chemistry ＆ Chemical Engineering, Anqing Normal College, Anqing , Anhui 246011, P R. China;2Department of Public Basic Courses; Anqing Vocational and Technical College; Anqing, Anhui 246003, P R. China) |
| |
| Abstract: | The calculation theory was introduced for a regression. The function grammar of LINEST（known_y＇s, known_x＇s, const, stats） was explicated. Added a group of equation, the method with a regression solution a multiple linearity equation was introduced. An example of solution linearity equation was given. |
| |
| Keywords: | Linearity Regression Multiple Linearity Equation LINEST Function Data Analysis Excel |
| 本文献已被 维普 等数据库收录！ |
