Excel回归分析在未开采煤层瓦斯含量预测中应用

Linear Regression Analysis Using Excel and Application inPrediction of Gas Content

未开采煤层瓦斯含量及影响因素研究,是煤矿安全生产的重要基础研究工作.以晓南矿未开采15-1#煤层为例,根据多元线性回归分析的数学原理,利用Microsoft Ex-cel工作表进行多元回归分析的方法,建立煤层瓦斯含量预测模型,对其进行了瓦斯含量预测。通过预测结果与实际情况的比较,可以得知Excel多元回归对瓦斯含量的预测精度较高。得出埋藏深度(m)、煤层厚度(m)、煤质、顶底板泥砂岩比是影响煤层瓦斯含量的主要因素。为未开采煤层瓦斯含量的研究提供了科学方法,并为煤矿的安全开采提供了基础资料。

The study of gas content and impact factor of the unmined coal seam is an important fundamental research. This paper takes the 15-1# coal seam of Xiaonan mine as an example ,according to the mathematic principle of multi - linear regression , using Microsoft Excel sheet as multiple regres sion analysis methods ,establishs forecasting model of coal gas and forecasts the gas content . Through comparing the results of and the actual situation,we konw that the forecasts of Excel mul tiple regression on the gas content is more accurate.And that buried depth （m）, coal seam thick ness （m）, coal, ratio of roof and floor of cement sandstone is the main factor of the impact of gas content .This study provides a scientific method about studying the gas content of the coal seam unmined and the basic data about the safe mining.