运用Excel对二氧化硫颜色与浓度的回归分析  

Regression Analysis of Sulfur Dioxide Color and Concentration Using Excel

作　　者：刁光成[1] DIAO Guangcheng(Shanxi Conservancy Technical Institute,Yuncheng 044004,Chin)

机构地区：[1]山西水利职业技术学院,山西运城044004

出　　处：《太原师范学院学报（自然科学版）》2018年第2期22-24,共3页Journal of Taiyuan Normal University:Natural Science Edition

摘　　要：首先利用Excel绘出二氧化硫在不同浓度下的颜色值和物质浓度的XY散点图,尝试建立与样本点拟合较好的回归模型;然后运用Excel数据分析,得出回归分析的结果,从结果中观察几个主要项目参数,如Multiple、R Square、SS、F、残差平方和等[1-3],与规定参考值进行对比,若在允许范围内则证明建立的回归模型可行,若远远超出允许范围,则重新建立模型再进行回归分析;最后通过观察样本残差图,进一步判定选用的回归模型的合理性,模型拟合效果,给出的数据可信度.To use Excel to draw the XY scatter plot of the color and substance concentration of sulfur dioxide at different concentrations,and tries to establish a regression model with a good fitting of the sample points.Then the results of the regression analysis are obtained by using the Excel data analysis,and the parameters of several main items,such as Multiple,R Square,SS,are observed from the results.F,residual square sum and so on,compared with the specified reference value,if the regression model is proved to be feasible in the permitted range,if it is far beyond the allowable range,the model is re established and then the regression analysis is re established.Finally,the rationality of the regression model is determined by observing the sample residual graph,and the model fitting effect is determined.The reliability of the data is given.

关 键 词：多元线性回归模型 二次多项式回归模型 残差 拟合 置信区间 

分 类 号：O29[理学—应用数学]