多元回归分析在预测中的应用

Usage of Multivariate Regression Analysis in Forecast

在多元回归数学模型基础上，运用Ｅｘｃｅｌ软件中的相应函数，快速地求得正规方程系数矩阵、逆矩阵及回归系数，同时提出了多元回归模型的检验过程，包括Ｒ检验、Ｆ检验和ｔ检验以及具体的使用方法，最后提出了多元回归方法的应用步骤．

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.