摘要
为了使繁琐、耗时的实验数据的计算分析和图形表达变得容易和快捷,减少数据处理的误差,提高结果的统计性和准确性,也为了进一步加强实验的综合性,培养学生应用计算机处理实验数据和绘图的能力,本文对于将Excel电子表格用于电导(率)法测定醋酸解离常数的实验数据的处理和表达方法进行了研究,分别采用算术平均值法、cΛm-1/Λm线性回归分析-图解法和本文提出的lg{Λ2m/[Λm∞(Λm∞-Λm)]}-lgc线性回归分析-图解法处理两组实验数据,并对处理结果进行了对比和分析.
In order to make complicated and tedious calculation, analysis and graphic expression of experimental data simple and fast, to reduce data treatment error, to strengthen statistical meaning and accuracy of result, and also to further synthesis of experiment for training students＇ ability to treat data and to graph with computer, an application of Excel to the experimental data treatment and expression in conductivity determination of the dissociation constant of acetic acid has been studied. Three methods of arithmetic mean, cΛm- l/Λm linear regression analysis-graphics and lg{Λm^2/[Λm^∞（Λm^∞-Λm）]}-lgc linear regression analysis-graphics advanced by this paper have been utilized to treat two groups of experimental data with results being compared and analyzed.
出处
《首都师范大学学报（自然科学版）》
2006年第4期39-43,47,共6页
Journal of Capital Normal University：Natural Science Edition
关键词
EXCEL
算术平均值
标准偏差
线性回归分析
图解法
回归方程
截距
Excel, arithmetic mean, standard deviation, linear regression analysis, graphics, regression equation,intercept
