This article introduces how to use the EXCEL method and the minimum dualistic multiplication method to do the regression analysis of coal calorific power and get linear regression equation.

• 介绍了利用最小二乘法和EXCEL两种方法进行煤发热量的回归分析,求得线性回归方程,并对回归方程的显著性进行检验,通过对计算过程的比较,利用EXCEL进行回归分析,简便快速,容易普及。