基于Excel的最短距离聚类分析法在化学分析数据中的应用

Application of Clustering Analysis in Chemical Analysis Data With the Shortest Distance Based on Excel

本文利用最短距离法对10个矿区的化学分析数据进行了聚类分析,通过使用Excel表格对数据进行了简单快速处理,样品结果最终分为7类,分类基本与所在矿区实际情况相符。

In this article the clustering analysis with the shortest distance was carried out, which these chemical analysis data came from 10 different mining areas. The data was quickly and easily calculated based on excel spreadsheets. The final results was divided into 7 categories, which was consistent with actual condition of the mining area.