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

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

作　　者：魏建录[1] 李婷[1] 班一禾 

机构地区：[1]河南省地质矿产勘查开发局第三地质矿产调查院,河南信阳464000

出　　处：《山东化工》2015年第17期166-168,176,共4页Shandong Chemical Industry

摘　　要：本文利用最短距离法对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.

关 键 词：聚类分析 EXCEL 化学分析数据 最短距离 

分 类 号：TQ014[化学工程]