乙酸乙酯皂化反应实验数据处理方法对比分析  

Comparison and Analysis of Method to Experimental Data Processing of the Acetic Ether Saponification

作　　者：刘红燕[1] 赵尧敏[1] 李英华[1] 何方 张艳丽[1] LIU Hong-Yan;ZHAO Yao-Min;LI Ying-Hua;HE Fang;ZHANG Yan-Li(School of Materials and Chemical Engineering,Zhongyuan University of Technology,Zhengzhou 451191,China)

机构地区：[1]中原工学院材料与化工学院,河南郑州451191

出　　处：《化学教育（中英文）》2023年第22期57-63,共7页Chinese Journal of Chemical Education

基　　金：河南省高等学校重点科研项目(22B430035);中原工学院课程思政示范课程建设项目(2022ZGSZKC002);中原工学院教学改革研究与实践项目(K2021YY009)。

摘　　要：在电导率法测定乙酸乙酯皂化反应动力学实验中,不同的数据处理方法得出的结果不同。基于31组学生的原始实验数据,分别采用线性、非线性、指数等3种函数程序对测量数据进行拟合处理,从原始数据的测量、计算结果、相关系数等3个方面进行了对比。研究表明,后2种方法得到的结果比较接近,均优于第一种方法,且采用指数函数拟合法能够达到更好的拟合效果,获得速率常数和活化能的标准偏差也较小。采用多种数据分析方法,不仅提高了学生分析结果的准确度,而且拓展了学生对计算机软件的应用能力。In the experiment of determining the saponification kinetics of ethyl acetate by conductivity method, the different results were obtained by different data processing methods. Based on the original experimental data of 31 groups from students, the linear, nonlinear and exponential function programs were used to fit.Then, the measurement, calculation results and correlation coefficient of the original data were compared.It was indicted that the results from the latter two methods are close and better than the first method. Moreover, the exponential fitting method can achieve the fitting effect with smaller standard deviation of activation energy. Therefore the accuracy of analysis results and the application ability computer software by students can be improved via the variety of data analysis methods.

关 键 词：乙酸乙酯皂化 线性拟合 非线性拟合 指数拟合 ORIGIN 速率常数 活化能 

分 类 号：G63[文化科学—教育学]