Excel二元回归分析在预测开滦动力煤发热量中的应用  

Excel binary regression analysis application in predicting calorific value of steam coal in Kailuan

作　　者：丁卫清[1] DING Wei-qing(Kailuan(Group)Co.,LTD.,Tangshan,Hebei 063000,China)

机构地区：[1]开滦(集团)有限责任公司,河北唐山063000

出　　处：《煤炭加工与综合利用》2025年第3期88-92,共5页Coal Processing & Comprehensive Utilization

摘　　要：利用Excel回归分析,建立了开滦钱家营矿动力煤发热量与全水分和灰分的关系的预测公式,并解释了Excel表格计算时生成的回归统计、方差、回归参数、残差表等的意义,该公式虽然不能代替实验数据,但方便快捷,可用于检验异常数据,能够为厂矿内部调控、指导和服务生产提供参考,为开滦其他的矿井及同行建立动力煤发热量预测公式提供了借鉴。By using Excel regression analysis,a prediction formula for the relationship between thermal coal calorific value and total moisture content and ash content ofQianjiaying coal mine in Kailuan is established,and the significance of regression statistics,variance,regression parameters and residual table generated in Excel table is explained.Although this formula cannot replace experimental data,it is convenient and fast,and can be used to test abnormal data.It can provide reference for the internal control,guidance and service production of factories and mines,and provide reference for other Kailuan mines and counterparts to establish thermal coal calorific value prediction formulas.

关 键 词：动力煤 EXCEL 回归分析 发热量 预测 

分 类 号：TQ533.4[化学工程—煤化学工程]