基于Excel的火炮射击精度模糊聚类分析

介绍了由模糊聚类分析和Excel相结合的火炮射击精度分析方法。以某炮连9门火炮为研究对象，以其试验射击中的炸点偏差为样本指标，按照模糊聚类分析步骤，首先采用打分法对样本数据进行了标准处理，然后利用Excel工作表分别求出了样本数据的模糊相似矩阵和模糊等价矩阵，最后对这9门火炮进行了动态聚类。结果表明：射击精度较高的为2、4和9号炮，次之为5号和6号炮，再次之为1号和7号炮，较差的为3号炮和8号炮。这样就可以根据作战任务性质的不同，对火炮进行适当编组，提高其作战效能。

Fuzzy Clustering Analysis of Gun Firing Accuracy Based on Excel

The combination analysis method of gun firing accuracy combined fuzzy clustering analysis with Excel was introduced.Taking 9 guns in one gun battery as research objects,and taking their burst point deviation in test fire as sample index,at first,according to steps of fuzzy clustering analysis method,the sample data was standardized by use of marking method.Then both its fuzzy similar matrix and fuzzy equivalent matrix were figured out by means of Excel.Lastly,9 guns' firing accuracy was clustered dynamicall...