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

Application of Excel for Processing Data of Analytical Chemistry Experiment

分析化学教学实验的分析结果应以学生总体平均值为准 .对学生的分析结果必须核实 ,对其中的异常值要用统计学方法进行检验 ,并计算相对误差以便评定成绩 .使用计算器完成这些工作存在实际困难 .运用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.