摘要
治理和利用矿井瓦斯的前提条件是成功预测瓦斯含量。建立多元拟合线性预测模型,依据Excel软件自带的统计函数求取自变量系数是预测的关键所在。根据得到的某煤层预测模型公式,借助绘图软件绘制瓦斯含量等值线图,并与探采资料进行了对比,可以看到这种模拟与探采结果是基本符合的。
The prerequisite for treatment and utilization of mine gas is the successful prediction of gas content. Establishing multivariate fitting linear prediction model and calculating the independent variable coefficient according to the statistical function of Excel software is the key to the prediction. According to the prediction model,the gas content isoline map is drawn by drawing software. Compared with the exploration and mining data,it can be seen that the simulation is basically consistent with the exploration and mining results.
出处
《陕西煤炭》
2017年第5期51-53,共3页
Shaanxi Coal
关键词
瓦斯
多元线性拟合模型
Excel软件统计函数
等值线图
探采对比
gas
multiple linear fitting model
Excel software statistical function
contour map
exploration andmining comparison
