| 应用Excel处理分析化学教学实验数据 |
| |
| 引用本文： | 李志强.应用Excel处理分析化学教学实验数据[J].首都师范大学学报(自然科学版),2004(Z2). |
| |
| 作者姓名： | 李志强 |
| |
| 作者单位： | 首都师范大学化学系 北京100037 |
| |
| 摘 要： | 分析化学教学实验的分析结果应以学生总体平均值为准 .对学生的分析结果必须核实 ,对其中的异常值要用统计学方法进行检验 ,并计算相对误差以便评定成绩 .使用计算器完成这些工作存在实际困难 .运用Excel软件处理数据简便快捷 .以酸碱滴定分析实验为例 ,介绍Excel处理实验数据的具体应用 .
|
| 关 键 词： | 分析化学 数据处理 Excel 结果核实 异常值检验 相对误差 |
Application of Excel for Processing Data of Analytical Chemistry Experiment |
| |
| Li Zhiqiang.Application of Excel for Processing Data of Analytical Chemistry Experiment[J].Journal of Capital Normal University(Natural Science Edition),2004(Z2). |
| |
| Authors: | Li Zhiqiang |
| |
| Abstract: | 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. |
| |
| Keywords: | analytical chemistry data processing Excel check of results statistical test of outlier relative error |
| 本文献已被 CNKI 等数据库收录！ |
