Excel在乙酸乙酯皂化反应三参数非线性拟合中的应用  

Application of non-linear fitting capability of Excel in processing experiment data of ethyl acetate saponification

作　　者：向明礼[1] 曾小平[2] 翟淑华[1] 赵志刚[3] 

机构地区：[1]四川大学化工学院,成都610065 [2]绵阳师范学院物理电子信息工程系,绵阳230000 [3]西南民族大学化学与环境保护学院,成都610041

出　　处：《西南民族大学学报（自然科学版）》2004年第1期16-20,共5页Journal of Southwest Minzu University(Natural Science Edition)

摘　　要：将Excel 2000用于乙酸乙酯皂化二级动力学反应的实验数据处理中.在简化实验条件下,无需测定反应初始时 刻的电导率L0和反应终了时的电导率L∞,无需编程,快速、方便地实现L0、L∞和反应速率常数k三个参数的非线性拟合.Excel 2000 was employed to process experimental data of ethyl acetate saponification. Even the experiment was done in a simple way in which the conductance of reactive system at the initial moment and that after reaction were not tested, optimum value of important parameters including rate constant can be obtained conveniently and quickly.

关 键 词：EXCEL 乙酸乙酯 皂化反应 最小二乘 非线性拟合 动力学 

分 类 号：O621.256.5[理学—有机化学] TP317.3[理学—化学]