浅谈用Excel对井田煤质数据进行审核

Discussion on Using Excel to Audit Mine Coal Property Data

利用Excel中的分析工具对山西阳泉某煤层的氢含量与工业分析测试结果进行回归分析,根据分析结果建立数学模型,对测试结果进行审核,从而提高了测试结果的可靠性和准确性,更好地反应了煤样的属性。

By using Excel analysis tools, analyzed the Hydrogen content and industrial analysis results of coal seam in Shanxi Yangquan by regression method. According to the analysis result establish Mathematical model and audit the test result. To improve the reliability and accuracy of the test results, reflect the attribute of coal sample preferably