Excel在地球化学数据处理中的高级应用

摘要

The Excellfunctions of chart drawing and data computing facilitate geochemical data processing.With studying in the principle of geochemical data processing this paper explains the calculation steps of the triangular diagram,the frequency histogram,the probability ruling paper graphical method for anomaly threshold,the multifractal method to calculate anomaly threshold,R cluster analysis,and discriminant analysis.These methods are entirely applicable to geochemical data processes.%Excel强大的图表绘制和数据计算能力，为地球化学数据的处理提供了便利。在研究地球化学数据处理原理的基础之上，详细解释了三角图解，频率直方图，概率格纸图解法求异常下限，多重分形法计算异常下限，R型聚类分析和判别分析的具体计算步骤。这些方法有利于地质科技方面的研究。