论文部分内容阅读
利用EXCEL软件中的指数平滑分析工具对贵州省2000年至2010年11年的煤炭产量数据进行分析,分别测算几个不同平滑指数下的一次指数平滑结果,根据偏差平方最优原理选择合适的平滑指数,再通过二次指数平滑,得出贵州省煤炭产量的趋势模型。
Exponential smoothing analysis tool in EXCEL software was used to analyze the data of coal production in Guizhou Province from 2000 to 2010 for eleven years. The exponential smoothing results under several different smoothing indices were calculated respectively. According to the optimal principle of deviation square, Index, and then through the second exponential smoothing, come to Guizhou Province coal production trend model.