excel解决灰色预测模型.doc

《excel解决灰色预测模型.doc》由会员分享，可在线阅读，更多相关《excel解决灰色预测模型.doc（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、【精品文档】如有侵权，请联系网站删除，仅供学习与交流excel解决灰色预测模型.精品文档.2003 10 75 u8260X 451u8260X B-11124”-11124R 759; R 213; R 264-11138d t + aY-11247t= -11247(3)100826013 (2003) 0520451203“ GM (1, 1) u8212X, u61623Xu8212X GM (1, 1) : Y t= (X 0 -a) e2at+a ( t= 0, 1, 2u8250Xu8250X , n) (4)-7516“ , u8222Xu731Xu732X“-7666X 0“

2、-7666( t= 0 ) -7653, u8212Xu732Xu8222Xu61623X, u402X, u8212Xu61623Xu8222Xu732Xu64258X“nnnn GM (1, 1) u8212X GM u8212Xu61623Xu8250X = ( u728Xt= 1nZt2 ) (u728Xt= 1nX t ) - ( u728Xt= 1Zt) ( u728Xt= 1X t Z t) , u8240X 1 ” , M icrosoft u732X O f n (u728Xt= 1Z t2 ) - (u728Xt= 1nZ t)2nn(5)f ice2000 E xcel

3、u8240Xu8212X GM (1, 1) , GM u8212Xn(u728Xt= 1a = ( u728Xt= 1nZt2) - (u728Xt= 1X t ) ( u728Xt= 1Zt)2Zt) - n ( u728Xt= 1X t Z t ) n(6)1. 2. 4 X tX t1”1. 1”u8230XS X t= Y t- Y t- 1 (t= 1, 2, u8250Xu8250X , n)1. 2. 5”u8224X C ”u731X(7)p 17 u8211Xu8218Xu8224Xu730X, O ffice2000X t”t= X t- X t ( t= 1, 2, u

4、8250Xu8250X , n ) SA S 6. 12 1. 2u8212X GM (1, 1) u61623X 1 3 “ S 1 ” S 2:nn n + 1 u8225X“ X t ( t= S 1=u728Xt= 1(X t- X )2 ( X =u728Xt= 1X t) (8)0, 1, 2, 3u8250Xu8250X , n) , :1. 2. 1 X t“Y t:t S 2=nu728Xt= 1n(t- l)2nnu728Xt= 1nnt(9)Y t= u728X X t (t= 0, 1, 2u8250Xu8250X , n )i= 01. 2. 2 (1)Y t (2)

5、 C = S 2 S 1 p = p t- l 0. 6745S 1 = u728X k(10)Zt= (Y t+ Yt- 1) 2 ( t= 1, 2, u8250Xu8250X , n ) (2)“ t- l 0. 6745S 1 n ( u728X k(11)1. 2. 3 GM (1, 1) u8212X Y tY t1. 3 Cp , 1 ”, u8212X :u8260Xu732Xu8230Xu732X“ :, u711Xu730X510632 (1961- ) , , ” , , X t= Y t- Y t- 1 (t= n+ 1, n + 2, u8250Xu8250X , n

6、+ k ) (12)1. 4 Excel “: ”u61623X1. 4. 1 2 Thank you for trying Nemo PDF To Word 3.0.This free trial version is limited to convert only one page for you to evaluate Nemo PDF To Word 3.0. If you wish to obtain unrestricted functionalities of Nemo PDF To Word 3.0, please visit: to buy the full version.