应用Excel处理分析化学教学实验数据  

Application of Excel for Processing Data of Analytical Chemistry Experiment

作　　者：李志强[1] 

机构地区：[1]首都师范大学化学系,北京100037

出　　处：《首都师范大学学报（自然科学版）》2004年第S2期31-33,共3页Journal of Capital Normal University：Natural Science Edition

摘　　要：分析化学教学实验的分析结果应以学生总体平均值为准 .对学生的分析结果必须核实 ,对其中的异常值要用统计学方法进行检验 ,并计算相对误差以便评定成绩 .使用计算器完成这些工作存在实际困难 .运用Excel软件处理数据简便快捷 .以酸碱滴定分析实验为例 ,介绍Excel处理实验数据的具体应用 .Population mean of all the students in a teaching experiment of analytical chemistry should be regarded as the certified value.Before evaluating the results of every student,the results should be checked,the outlier should be tested with the method of statistics and the relative error should be caluculated.It's troublesome to process data with a counter.Application of Excel software makes it simple and convenient.An acid-base titration experiment is provided as example to illustrate how to process data with Excel.

关 键 词：分析化学 数据处理 EXCEL 结果核实 异常值检验 相对误差 

分 类 号：O651[理学—分析化学]