解析法处理沉降分析实验数据及在Excel中的实现  

Data Processing of Sedimentation Analysis by Analytical Method and by Excel

作　　者：刘本才[1] 王玉峰[1] 张秀成[1] 

机构地区：[1]东北林业大学理学院,黑龙江哈尔滨150040

出　　处：《实验室研究与探索》2013年第10期14-16,20,共4页Research and Exploration In Laboratory

基　　金：黑龙江省教育科学"十一五"规划课题(XGZD07009)

摘　　要：基于解析法用Excel对沉降分析实验数据进行了处理。将含4个参数的函数作为沉降曲线的数学模型,推导了反映颗粒大小的分布函数。利用Excel的规划求解将沉降方程拟合得到4个参数后,由计算出的分布函数值绘制了粒度分布曲线。通过对分布函数的一阶微分方程求解和对粒度分布曲线进行图解,分别得到了含量最多的颗粒半径。在处理过程中应用了Excel的图表计算、图解、单变量求解和规划求解等功能。结果表明,用这些方法处理数据,提高了准确性,重现性好,效率高。An analytical method is developed for data processing of sedimentation analysis. The mathematical model for sedimentation curve has four parameters. The function of particle size distribution is deduced, from the function the curve of particle size distribution can be drawn. The most probable radius of particles is obtained by calculation of first derivative of the function of particle size distribution or by the curve. These are performed with Microsoft Excel, using graphical technique, Goal Seek, Solver and so on. The results show that the method of data processing needn＇t write program in a high-level language, and is convenient, precise and reliable.

关 键 词：沉降分析 解析法 数据处理 

分 类 号：O648.2[理学—物理化学]