应用Excel对一元线性回归模型的分析

Analysis to once basic linearity regression model by applying the Excel

应用Excel的函数、图表及数据分析工具等功能,对一元线性回归模型进行分析,进而得出数据间的关系、建立回归方程,并对结果进行预测和检验,使解决实际问题的能力大大提高了。

Applied the Excel functions, tables and data analysis tools, the once basic linearity regression model was analyzed, then the relationship was obtained among data, and the regression equation was built, so the results can be predicted and inspected, and greatly enhanced our ability to solve practical problems.