摘要
介绍了用MicrosoftExcel软件对平均值、标准差、偏度和尖度等沉积物粒度分布参数进行统计计算(矩法计算)的方法,包括函数的调用和具体操作过程。该方法操作简单、快捷,使过去完全无法对大量样品进行的粒度参数统计计算变得极其容易。在计算速度、可靠性、适用性以及绘图功能等方面,用Excel对沉积物进行粒度分布参数的统计计算都显著优于图解法粒度计算和各种用于粒度分析的图像分析系统。此外,该方法也可用于油层物理研究中的孔隙和喉道分布参数的计算。
This paper introduces a method for statistic calculation of grain size distribution parameters (average value , standard deviation, skewness and kurtosis) of sediments using Microsoft Excel, which includes using function and the concrete operation process. Because of its easiness and shortcut, this method can be used to calculate numerous samples at a short time. Compared with the diagrammatic calculation, the statistic calculation by Excel is quicker, more trusty and applicable. It also excels all kinds of image analysis system in performance. Additionally, this method can also be used to calculate porosity and throat size distribution parameters.
出处
《成都理工学院学报》
CSCD
1999年第2期195-199,共5页
Journal of Chengdu University of Technology