| 应用Excel规划求解处理表面张力测定实验数据 |
| |
| 引用本文： | 张进,姚思童,刘利,吕丹.应用Excel规划求解处理表面张力测定实验数据[J].中国现代教育装备,2011(3):45-46,50. |
| |
| 作者姓名： | 张进 姚思童 刘利 吕丹 |
| |
| 作者单位： | 沈阳工业大学,辽宁沈阳,110870 |
| |
| 摘 要： | 在表面张力测定实验数据处理中,利用Excel2007规划求解功能对表面张力和浓度关系中的待定参数进行非线性最小二乘拟合求解,得到拟合参数a,b。结合希斯科夫斯基经验公式和吉布斯吸附等温式可方便求出表面吸附量的数值,并绘制表面吸附量和浓度的关系曲线。整个处理过程无需编程,可快速、简便、准确地完成数据处理任务。
|
| 关 键 词： | 表面张力 Excel 规划求解 数据处理 |
The application of Excel solver on handling data in the surface tension experiment |
| |
| Zhang Jin,Yao Sitong,Liu Li,Lv Dan.The application of Excel solver on handling data in the surface tension experiment[J].China Modern Education Equipment,2011(3):45-46,50. |
| |
| Authors: | Zhang Jin Yao Sitong Liu Li Lv Dan |
| |
| Institution: | Zhang Jin,Yao Sitong,Liu Li,Lv Dan Shenyang university of technology,Shenyang,110870,China |
| |
| Abstract: | Excel2007 solver function was used to get the unknown parameters a and b by nonlinear least-squares fitting between the surface tension and the concentration,in handling data of the surface tension experiment.The value of surface adsorption quantity was easily got according to empirical formula and gibbs adsorption formula,and the curve between surface adsorption quantity and the concentration also can be mapped by Excel.The whole process of handling data need not write program,and is quick,easy and accurat... |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
