摘要
在多元回归数学模型基础上,运用Excel软件中的相应函数,快速地求得正规方程系数矩阵、逆矩阵及回归系数,同时提出了多元回归模型的检验过程,包括R检验、F检验和t检验以及具体的使用方法,最后提出了多元回归方法的应用步骤.
According to the math model of Multvariate Regression Analysis, this paper makes use of correspondent functions of Excel software in order to obtain a quick answer for it.At the same time,the artical puts forward inspecting process for the multivariate linear regression model (R inspection. F inspection, t inspection) and concrete usage method. Fimally, the usage steps of the multivariate regression analysis mehtod are raised.
出处
《河北工业大学学报》
CAS
1996年第3期57-61,共5页
Journal of Hebei University of Technology
关键词
多元回归分析
经济预测
EXCEL软件
数学模型
Mutivariate regression analysis
Economic forecast
Excel software
Mathematical model
R inspection
Finspection