Excel在绘制胶质层曲线中的应用

Application of excel in drawing the curve of the plastometric layer

介绍了利用Excel绘制胶质层曲线的方法及计算胶质层最大厚度Y值,针对实验获得的20组数据分别采用手工和Excel表格绘制胶质层曲线,并对其结果及差值进行数理统计。通过t检验表明:Excel绘图法与人工绘图法对胶质层测定无显著性差异,该2种方法可互相代替;Excel绘图法可提高胶质层的测试精度。

This paper introduced the method of using the excel to draw the plastometric layer curve,and the calculation of maximum thickness Y of plastic layer,regarding to 20 groups of data obtained from the experiments,the manual method and excel method were used to draw the curve of the plastometric layer,the mathematical statistics of results and difference was done.Throught test we can see that excel cartography and manual drawing method have no significant difference,they could replace each other;the excel cartography could improve the testing precision of plastometric layer.