用Microsoft Excel处理氧弹法燃烧热的实验数据  

Data processing of determination of heat of combustion in oxygen bomb by Microsoft Excel

作　　者：刘本才[1] 张秀成[1] 王玉峰[1] 

机构地区：[1]东北林业大学理学院,黑龙江哈尔滨150040

出　　处：《计算机与应用化学》2008年第10期1243-1247,共5页Computers and Applied Chemistry

基　　金：黑龙江省教育科学"十一五"规划重点课题(XGZD07009);东北林业大学教育教学研究课题(03023)

摘　　要：测定燃烧热是大学物理化学实验中的一个重要实验,用手工处理数据既费时,误差又大。本文介绍应用Microsoft Excel软件的函数、图解、多项式拟合、单变量求解等多种功能,处理氧弹法测定燃烧热数据的新方法。结果表明,这些方法不需编程,数据处理简单快捷;比手工作图法方便,且更准确。The determination of heat of combustion in oxygen bomb is one of the important experiments of physical chemistry. The data processing of this experiment by manual plotting will take a long time, and may get inaccurate results. The new methods of data processing of the experiment by Microsoft Excel were introduced, which included the uses of the functions of Microsoft Excel, graphical technique, fitting of polynomial and goal seek, etc. These methods which needn＇t program in a high-level language are simple, convenient and fast. The results showed that they are more advantageous and accurate than manual plotting.

关 键 词：MICROSOFT EXCEL 燃烧热 数据处理 

分 类 号：O642.3[理学—物理化学] TP399[理学—化学]