应用LINEST函数推算煤的发热量与灰分、水分的线性方程

摘要

发热量是动力煤质量评价、销售定价的主要指标，可用LINEST函数推算出发热量与灰分、水分的线性相关性。通过F检验、t检验、误差分析证明多元线性回归方程具有很强的适应性，能利用方程准确地预测煤的发热量。%Caloriifc value is the main index of quality evaluation and sales price of power coal, LINEST function can be used to calculate the linear correlation between heat and ash and moisture. The F test, t test and error analysis prove that the multiple linear regression equation has strong adaptability, and can accurately predict the caloriifc value of coal.